auto filter with error value

G

Guest

the auto filter doesn't work for the columns that contain "#value!".
I am trying to get the top 10 items in the column and like to ignore those
error values, i.e. "#value!".
Thanks!
 
D

Dave Peterson

Maybe you can use a helper column and a formula like:

=if(iserror(a2),"",a2)

Then apply your filter to that column.
 

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

Filter (blanks) with two or more unique values not working 1
Compting 99% of a col range while autofilter is on. 1
Filter for a symbol 1
Auto Filter 4
minimum value using auto filter 3
Error in formula after auto-filtered 2
Return value from the top of an auto filer list. 1
Average value only for the filtered area.. 4

Top