i want to make match run from bottom to top, here is the formula im
working with:

(ADDRESS(MATCH("Client Aged A/R", A$1:$A198, 0), 10))
--------------------


right now it matches from A1 to A198 and returns the address of the first
time it sees "Client Aged A/R", i really want it return the last time it
sees "Client Aged A/R", which esentially would be the same thing as going
from a198 to a1 and returning the first.

thanks in advance
ryan


--
ryan00davis
------------------------------------------------------------------------
ryan00davis's Profile: http://www.excelforum.com/member.php...o&userid=37344
View this thread: http://www.excelforum.com/showthread...hreadid=570881