Forum Discussion
Filtering in Excel using a Table
First - Is there a way to format a table in Excel where you can hide redundant cells, but maintain the ability to filter for the data I need?
Example:
Here the three instances of the Person 'Granny Smith' is redundant, whereby, only one row is wanted, with the name and item they sell, but because they sell 3 different types of apple, 3 rows are needed. They also sell apples in two locations.
The same would be for 'Chester McCheddar', where they sell 3 types of cheese in the same city.
The idea is that I would want the 3 rows to be integrated together, where I have only 1 row, however, I still want to be able to filter by type and location without losing data.
Second - Can this be integrated into Excel on the cloud for multiple people to maintain / use the workbook?
It would be preferable this is used in MS Excel, however I believe MS Access might be the way to go, but am exploring options.
Please ask further questions if required.
1 Reply
You can conditionally format the font colour to match the cell fill colour.
That only changes the visual appearance of a flat data structure. If you wish to have one to many links using foreign keys that would require considerable effort to set up and maintain in Excel.
