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 Natural Gas Futures (symbol is NG) and Crude Oil, Light Sweet Futures (symbol is CL) when the date is after June 1, 1999.