AutoFilter Top10 not working

  • Thread starter Thread starter rich
  • Start date Start date
R

rich

Sorry for rephrasing an earlier question, but a tough deadline is
aproaching.........

In a very large workbook, the Autofilter>top10 function wont work on
several columns (works on some, not others). After setting the criteria
in the usual way, nothing happens. When I go back into the filter
dropdown, the filter shows it's still set to "all".

There are no gaps or spaces,no errors, and the column is formatted as a
number. The data is flat, no formula involved.


Help !
 
You say formatted as number, but is the data a "real number"?

If the data came in as text simply re-formatting won't change it.

You must force Excel to change the data.

Format to General.

Copy an empty cell.

Select the columns and Edit>Paste Special>Add>OK>Esc.


Gord Dibben MS Excel MVP
 
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

Autofilter Not working completely 2
Autofilter 10
Autofilter: Does Not Contain 2
AutoFilter issues 4
subtotals with custom autofiltering 1
Autofilter to filter out non-numeric rows 3
Autofilter not working on protected sheet. 1
Autofilter misses last line 7

Back
Top