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

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