Thread: auto filter with error value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cynthia Cynthia is offline
external usenet poster
  
Posts: 86
Default auto filter with error value
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!
Reply With QuoteReply With Quote