MIM Excel Add-in Tour:
Show When Function
 

Next Previous MIM Excel Add-in Main Menu

Show When Function

Create Show When queries quickly by pulling data entered on a spreadsheet. Enter the Show statements in a column on the spreadsheet. Enter the When statements in the next column.

The program will automatically fill in the Show-When Query Server dialog box with your fields. The program will skip a row and put the answers at the beginning of the next row. (For the following example Row 4).

Problem

For this example, let's find the Close of Dell and IBM when the date is after June 1, 1999.

Step by Step Solution

  1. Type the following information into the Excel spreadsheet: The Show statements are: Close of Dell, Close of IBM. The When statement is: Date is after June 1, 1999, Date is defined. When you are finished entering the data make sure you click back on the first entry. This cell (cell A:1) designates the starting point for the other entries.
  2. Select Show When from the MIM menu.

    3. Proceed to the next step.