Click here to reset your password. You MUST have a valid e-mail address so that you may receive the instructions to complete the reset.

If this is your first visit, be sure to check out the Board FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.

Megslow, by chance do you have any hidden rows? My previously stated exploratory approach wouldn't have found 'em. You could select all rows and unhide 'em. Or, select column F:F, choose the Edit | Find... menu command and search for 0. Do you get a "Microsoft cannot find..." message?

On 2002-04-03 09:20, Mark W. wrote:
Megslow, by chance do you have any hidden rows? My previously stated exploratory approach wouldn't have found 'em. You could select all rows and unhide 'em. Or, select column F:F, choose the Edit | Find... menu command and search for 0. Do you get a "Microsoft cannot find..." message?

I "unhid" any rows and columns. I deleted one previously hidden columns. I searched column F for zero values but none were found. The formula still returns zeroes.
Thank you for taking time on this. : )
Meg.

On 2002-04-03 06:43, Mark W. wrote:
Megslow, the formula, =INDEX(F:F,MATCH(9.99999999999999E+307,F:F)), should work just fine. I believe that you have a stray 0 somewhere in column F perhaps well beyond the row containing what you believe to be the last entry. Do this...

1. Select the cell containing what you believe to be the last entry.
2. Press Control+Down Arrow.

Is cell F65536 selected? If not you may have found a stray entry -- clear the contents of this cell. Repeat steps 1 thru 2 above (clearing all stray values) until you reach F65536. Now, does the formula produce the correct results?