business_analyst
Board Regular
- Joined
- Jun 5, 2009
- Messages
- 99
All,
I was sent a file from an associate that has the auto-filter on. I can tell that several rows of data are filtered out because there are gaps in the row numbers on the left side-bar. I also know which column was used to filter as it has the signature blue arrow (where as all other columns have a black drop down arrow). When I click on this blue arrow the filter options are displayed in a drop down, with "Custom..." already highlighted. However when I click on this and the "Custom" input box appears, it has no conditions in it. So I do not know what conditions were used in this filtering process.
Is there any way to view the custom filters that were set for that column? Any help would be greatly appreciated.
I was sent a file from an associate that has the auto-filter on. I can tell that several rows of data are filtered out because there are gaps in the row numbers on the left side-bar. I also know which column was used to filter as it has the signature blue arrow (where as all other columns have a black drop down arrow). When I click on this blue arrow the filter options are displayed in a drop down, with "Custom..." already highlighted. However when I click on this and the "Custom" input box appears, it has no conditions in it. So I do not know what conditions were used in this filtering process.
Is there any way to view the custom filters that were set for that column? Any help would be greatly appreciated.