Applying an AutoFilter to a string
 

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

Applying an AutoFilter to a string
 

What about " R-001*" as your filter: this will filter rows 2 & 3

"Hardip" wrote:

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

Applying an AutoFilter to a string
 

Or filter "Begins with" R-001" ?

"Hardip" wrote:

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

Applying an AutoFilter to a string
 

Hello Topper

I figured it out with the AutoFilter custom feature. I used 'contains' out
of the list.

It's very good and saves me a lot of time!!!

Thanks for responding - H

"Toppers" wrote:

Or filter "Begins with" R-001" ?

"Hardip" wrote:

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