Thread: index and match query
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default 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 With QuoteReply With Quote