Oberon70
Board Regular
- Joined
- Jan 21, 2022
- Messages
- 160
- Office Version
- 365
- Platform
- Windows
I have a table I have created with Power Query and I have an ID number in Column A. I know I can format customer with ;;; and what is in the cell will not display, but then it doesn't work with the filter either. Is there a way to have cells hidden, but the filter will still recognize the data?
View attachment 60671
I was hoping to only have the cell A1 visible and the rest to have the data, but not display, but also to still be recognized by the filter.
View attachment 60671
I was hoping to only have the cell A1 visible and the rest to have the data, but not display, but also to still be recognized by the filter.
Last edited by a moderator: