Dear NGs,

Good morning.  I want to use an IF statement to set a cell value to
"True" or "False" based on the following condition: If in 1 of the last
200 rows of the spreadsheet then TRUE, else FALSE.  I have found posts
that describe how to get the last value in a column using a number of
functions including the Index, Lookup, Isblank, and so on, but I've not
found any that address this specific question.  Of course, ROW() will
give you the row number and if I could find a function that gave me the
last row number I could test the difference for < 200 or > 200.

Any help on this would really be appreciated.

Thanks much.

Mike