Scan column for first of a list

[Chip]

I have a spreadsheet with over 20,000 lines. It is clothing and there are
styles, color, size, etc.

I would like to scan down column "A" and only have each style print once.
In other words, print the style only on the first one of an entire list of
the same style.

Can anyone help ? Thanks.

 

[Gord Dibben]

Select Column A

Data>Filter>Advanced Filter.

Check "unique records only" and "filter the list in place"

Print the visible cells.


Gord Dibben MS Excel MVP