How To Determine if Your In 1 of the last n rows

[Takeadoe]

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

 

[Don Guillett]

if all numbers you can match a number larger than possible less the rows
desired. Different if text or mixed.

=IF(ROW()>=MATCH(99999999,A:A)-200,"inrows","not")

 

[Takeadoe]

Don - Thank you! That was exactly what I had in mind!

Mike