Finding the last occurance of a value in a matrix

[Ayjay]

I have a matrix of 7 columns and 2000 rows of different whole numbers 1 thru 49. How do I find the last row in which each of these numbers appears?

[Azam Ali]

Hi Ayjay

try the follwing formula to identify las row of column A where there is a number

=MATCH(9.99999999999999E+307,A:A)

if it does not help, upload a sample workbook