index and match query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Perhaps Data > Filter > Autofilter on the col for "AA" would suffice ?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX AND MATCH QUERY ? 2
index and match help Please! 1
LOOKUP, MATCH MORE MATCHES IN TWO COLUMN 1
Match, Index, Indirect ? 1
Index Match on Columns and Rows 0
Index and Match 3
Cell Counter/Increment 2
INDEX MATCH SMALL 12

Back
Top