Guybrush Threepwood
New Member
- Joined
- Apr 21, 2012
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hi everyone.
Hope you are all well
So I've embarked on a journey to build a small list (up to 1,000 records) that other users can add to and then filter for various attributes to find what they want.
Pretty simple so far...but:
I need a list of attributes that can be added to each record in the list and then the user needs to be able to search and filter for any one of those attributes.
For example:
Record 1 has attributes of A, B and C
Record 2 has attributes of B and D
Record 3 has attributes of A
I need the user to be able to do a search and filter for attribute A and Record 1 and 3 will show. Search for attribute D and record 2 will show, etc.
Any ideas as to if there are functions in Excel that make this possible? I started off thinking this would be easy, until I realised after creating a separate column for each attribute you can't do a search/filter across all columns (to my knowledge), even in a pivot table.
Many thanks.
Hope you are all well
So I've embarked on a journey to build a small list (up to 1,000 records) that other users can add to and then filter for various attributes to find what they want.
Pretty simple so far...but:
I need a list of attributes that can be added to each record in the list and then the user needs to be able to search and filter for any one of those attributes.
For example:
Record 1 has attributes of A, B and C
Record 2 has attributes of B and D
Record 3 has attributes of A
I need the user to be able to do a search and filter for attribute A and Record 1 and 3 will show. Search for attribute D and record 2 will show, etc.
Any ideas as to if there are functions in Excel that make this possible? I started off thinking this would be easy, until I realised after creating a separate column for each attribute you can't do a search/filter across all columns (to my knowledge), even in a pivot table.
Many thanks.