FILTER REPORTS

  • Thread starter Thread starter Kate
  • Start date Start date
K

Kate

I have two columns:
Medication Name RX Route
Advil Oral
Advair Diskus Inhalation

I would like to show the top 100 medication names that our clinic uses.
There are over 3,000 names in my spreadsheet. I tried to use the Filter and
select TOP 10 BUTTON but when I do I get a Beep and nothing happens. What
am I doing wrong?
 
Filter only stores 1,000 occurrances so I would try not using filter. I
would try doing a pivot table and then you can show number of records for
that med, assume it appears more than once and you want to see the most
active to least.
 

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

Comparison tool between 2 spreadsheets? 1
Filtered Sort freezing up 1
SUMIF Formula not working 1
Report on upcoming dates 1
filters for selective columns? 2
filtering dates in a Pivot Table Report Filter 3
Hiding Rows 3
subtotal filter with growing range 2

Back
Top