Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find the second match using the match function
I need to use the MATCH function to find the second location within an array
of a value. This function be able to query a closed external workbook. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find the second match using the match function
if your range is from A2:a6 and the lookup value is in b7 then
=SMALL(IF(A2:A6=B7,ROW(A2:A6)-ROW(A1)),2) array entered (ctrl+shift+enter) "Ray" wrote: I need to use the MATCH function to find the second location within an array of a value. This function be able to query a closed external workbook. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find an exact match and go to that match | Excel Discussion (Misc queries) | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
how can we get unique values in match function for same match key. | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
Match Function Problem - Won't Find Certain Numbers | Excel Discussion (Misc queries) |