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)))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LookUp to Display Last Value Populated a in Range 13
Scrabble Value calculation for Welsh words 0
VBA- Excel Programming:- 0
Match function 1
Search for specific text within last non blank cell in a range 2
Match function...random search? 10
INA help 2
Last value 6

Back
Top