| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
search an array in reverse (bottom to top) order
I am using an INDEX & MATCH formula to search for the occurrence of a
specific text string within an array. I used the following formula: =INDEX($A$1:$A$20,MATCH("*Specific Text String*",$B$1:$B$20,0)) But this formula works its way down the array giving me the first occurrence of the "Specific Text". What I want is the last occurrence (or the one closest to the end of the array). Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I reverse name order from Last, First to First Last in Exc | Excel Discussion (Misc queries) | |||
| reverse order of numbers | Excel Discussion (Misc queries) | |||
| reverse order | Excel Discussion (Misc queries) | |||
| Reverse Data from bottom to top | Excel Discussion (Misc queries) | |||
| Sorting in reverse (from right-to-left and from top-to-bottom) | Excel Discussion (Misc queries) | |||
Threaded Mode
