R
ryan00davis
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
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