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 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.

The technique that Mark described is shown here, and there's code to
automate the process, if it's something you do frequently.

http://www.contextures.com/xlDataEntry02.html

To hide the duplicate Product Group headings, you can use conditional
formatting:

http://www.contextures.com/xlCondFor...html#Duplicate

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.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html