Advanced Filtering Technique Needed

  • Thread starter Thread starter carlos
  • Start date Start date
C

carlos

Hello. I have a spread sheet that is set-up as so:

Product Group Product Type
GroupA TypeA1
TypeA2
TypeA3

GroupB TypeB1
TypeB2

The entries in the Product Group Column are in a single
cell while their related Product Types are in multiple
cells. The list has 250 Product Groups and around 3000
Product Types.

I would like to "filter" by Product Group and see the
associated Product Types.

Thank you in advance for your guidance.
 
You could fill in all of the blank cells with the product group and then use autofilter on that column.

1. Select the area of your product group column adjacent to the product types.
2. Edit>Go to>Special>Blanks
3. Enter the formula =A2 (this assumes that the first product group is in A2)
4. Edit>Fill>Down
5. Select Column A
5. Edit>Copy
6. Edit>Paste_Special>Values

Now you will have the product group in every cell and you can use Data>Filter>Autofilter

Good Luck,
Mark Graesser
(e-mail address removed)



----- carlos wrote: -----

Hello. I have a spread sheet that is set-up as so:

Product Group Product Type
GroupA TypeA1
TypeA2
TypeA3

GroupB TypeB1
TypeB2

The entries in the Product Group Column are in a single
cell while their related Product Types are in multiple
cells. The list has 250 Product Groups and around 3000
Product Types.

I would like to "filter" by Product Group and see the
associated Product Types.

Thank you in advance for your guidance.
 
Back
Top