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.

Select Column A

DataFilterAdvanced Filter.

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

Print the visible cells.


Gord Dibben MS Excel MVP

On Sat, 24 May 2008 07:57:00 -0700, Chip wrote:

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.