Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Right now I'm finding the row of my first match with the following formula.
=MATCH($B$11,$B$16:$B$10024,FALSE)+15 However, with new data coming in, there may be more than one match that I need to know about. I'd like to use multiple cells to capture the row number of each subsequent match. My current approach is something like [A1] =MATCH($B$11,$B$16:$B$10024,FALSE)+15 [A2] =indirect("MATCH($B$11,$B$" & A1 & ":$B$10024,FALSE)+15") [A3] =indirect("MATCH($B$11,$B$" & A2 & ":$B$10024,FALSE)+15") Is there a more elegant way to find subsequent matches, rather than just doing a new match based on resetting the start of the match range? Thanks, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding matches ( | Excel Discussion (Misc queries) | |||
Finding matches (in Excel 2007) | Excel Discussion (Misc queries) | |||
finding exact matches | Excel Worksheet Functions | |||
Finding EXACT matches within separate rows | Excel Discussion (Misc queries) | |||
finding exact matches using vlookup | Excel Worksheet Functions |