| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
index and match query
I am using a match and index query however my results shows three rows the
same apart from the count of people how can i get the rows to follow down rather than it picks first row from list? i.e AA Diagnosis 23 AA Diagnosis 24 AA Diagnosis 25 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
index and match query
Perhaps Data Filter Autofilter on the col for "AA" would suffice ?
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "kate" wrote: I am using a match and index query however my results shows three rows the same apart from the count of people how can i get the rows to follow down rather than it picks first row from list? i.e AA Diagnosis 23 AA Diagnosis 24 AA Diagnosis 25 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| INDEX AND MATCH QUERY ? | Excel Worksheet Functions | |||
| Match Index | Excel Worksheet Functions | |||
| Match or Index Question | Excel Worksheet Functions | |||
| Match & Index | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Linear Mode
