How do I fix my Autofilter in Excel?

[JH]

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]

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