View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default How do I fix my Autofilter in Excel?

Can you type an example of the data you're filtering, the results you
expect to see, and the incorrect results that you get?

JH wrote:
I have a very large spreadsheet that I am trying to Autofilter. I have one
specific column that I am trying to filter by and it is not working properly
(I have tried all columns with the same results). The column that I am trying
to filter by has subtotals for all of the values (in different columns) that
I am trying to filter by at the bottom of the spreadsheet (the value that I
am trying to filter by is next to the subtotals in the correct column). These
subtotals are the ones that are not filtering properly. I always get
information that I have not filtered for & sometimes I don't even get the
correct information.

Please Help

JH



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html