Finding the Last Occurrence of a specific value in a column

[MarkVMcCullagh]

What is the easiest way to find the last occurrence of a value in a table using functions. I want to avoid VB if at all possible and note the row number and use it in an index function to report text adjacent to that last occurrence. I would normally use match but match only records the first match and not the last.

Thanks in advance

 

[hippiehacker]

if you read the explanation by t. valko in this thread then you might understand the formula

 

[Me_In_Va]

you know that you replied to a thread which is 11 years old?

SOmeone had to blow the dust out of the bits on the server's drives.

 

[subssubs]

And four MORE years later I found this thread useful!