G
Guest
Hi All
I'm designing a spreadsheet where using the AutoFilter will become
important. The information in the cell can have a one-to-one or one-to-many
relationship with other identifiers e.g. Cell B2-B4 might be populated as
follows:
Cell B2: R-001
Cell B3: R-001 R-002 R-010
Cell B4: R-002 R-010
When applying the AutoFilter I get the entire string in the selection (as
per the information in the cell). So I cannot filter on R-001 and get rows 2
- 3 in the results.
I appreciate the AutoFilter has limitations and I could populate a separate
row with each identifier (R-001 R-002 etc) but that would mean duplicating
the information in other cells. This will become unmanageable as the table
gets populated.
1. Is there a method to acheive this with AutoFilter or
2. Should I design the spreadsheet using a different method.
If the answer is 2, I'd appreciate a steer in the right direction.
Many thanks for reading the post and responding.
Regards
H
I'm designing a spreadsheet where using the AutoFilter will become
important. The information in the cell can have a one-to-one or one-to-many
relationship with other identifiers e.g. Cell B2-B4 might be populated as
follows:
Cell B2: R-001
Cell B3: R-001 R-002 R-010
Cell B4: R-002 R-010
When applying the AutoFilter I get the entire string in the selection (as
per the information in the cell). So I cannot filter on R-001 and get rows 2
- 3 in the results.
I appreciate the AutoFilter has limitations and I could populate a separate
row with each identifier (R-001 R-002 etc) but that would mean duplicating
the information in other cells. This will become unmanageable as the table
gets populated.
1. Is there a method to acheive this with AutoFilter or
2. Should I design the spreadsheet using a different method.
If the answer is 2, I'd appreciate a steer in the right direction.
Many thanks for reading the post and responding.
Regards
H