| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
search for date in long string of text
ok, this was kinda stupid, and im not sure why they make you do this, but i needed to add indirect() around the address: Code: -------------------- =IF(M200="","",MIN(INDIRECT((ADDRESS(MATCH("Client Aged A/R", $A$1:A198, 0), 10))):J200)) -------------------- anyways, now if anybody can help me figure out how to make the match run backwards, that would be awesome.... right now it searches from A1 and finds the first "client aged a/r" on the way down to A198; i want it to start at A198 and find the first "client aged a/r" on the way up to A1 oh, and while it seems to be the logical solution just changing a1:a198 to a198:a1 doesnt work, it automatically changes it back -ryan -- ryan00davis ------------------------------------------------------------------------ ryan00davis's Profile: http://www.excelforum.com/member.php...o&userid=37344 View this thread: http://www.excelforum.com/showthread...hreadid=570458 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract specific value from a long text string | Excel Worksheet Functions | |||
| Format cells with a formula (7 conditions). | Excel Discussion (Misc queries) | |||
| How do i insert a Address Bar kind of drop down list within MS Exc | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| Find nth instance of a character in a string | Excel Discussion (Misc queries) | |||
Threaded Mode
