How do I fix my Autofilter in Excel?

G

Guest

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
 
D

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?
 

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

need help on either doing a loop and counting specific values orusing subtotal function 2
subtotal function won't work 1
Return the filtered value into a specific cell 4
Average over autofilter results 4
Filter setting 3
How do I count rows in a filtered list when using AutoFilter? 5
Count the number of AutoFiltered records 6
No difference between SUM and SUBTOTAL (9) 1

Top