Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
AutoFilter on Protected Worksheet Excel 2003 | Excel Discussion (Misc queries) | |||
Multiple Excel versions. | Excel Discussion (Misc queries) | |||
Using autofilter and excel form format | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |