Excel Search - last value ina range

  • Thread starter Thread starter MXM
  • Start date Start date
M

MXM

I am attempting to search a large excel file for a given value. I ca
get it to turn up the first value that it finds via the match function
but I cannot create a function to show me where the last occurence i
the series is located. Is there a way to do this without sorting th
file in ascending order
 
Hi
to get the row number of the last occurence you may use the following
array formula (entered with CTRL+SHIFT+ENTER):
=MAX(IF(A1:A1000="your_value",ROW(A1:A1000)))
 
Back
Top