| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
make match run backwards
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look for match on two worksheets | Excel Worksheet Functions | |||
| How can I make the reference link match the new formatting of its | Excel Discussion (Misc queries) | |||
| How do i Match all COLUMNS? | Excel Worksheet Functions | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
