last instance in range excel cell location...

I just used the excellent formula =row(index(range,match(1,index,--(range)>0),0),0))) to give me the first instance of a number, but i am wondering if there is a formula to give me the last instance of the number as well? Maybe? This would save me much time if possible.

Thanks so much!

C

something like... =Lookup(2,1/(--(criteria_range)>0),result_range)

Thanks masteff, just to clarify (given the other example had the solution embedded within an AVERAGE call) in this instance possibly something like:

Please Login or Register  to view this content.

or simpler still

Please Login or Register  to view this content.

However, if as implied by your earlier formula & NBVC's interpretation thereof that not all numbers are valid (ie must be > 0) then his solution will work whereas the above would not.

Give a more specific example indicating the actual ranges and conditions to be met (if any)

So yes you would need to use the approach outlined already by NBVC, eg:

Please Login or Register  to view this content.

Though if you only intend to use this to retrieve dates you can dispense with O & P and just use

Please Login or Register  to view this content.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save