Scan column for first of a list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chip - 24 May 2008 15:57 GMT

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.

Reply to this Message

Gord Dibben - 24 May 2008 17:19 GMT

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

>I have a spreadsheet with over 20,000 lines. It is clothing and there are
>styles, color, size, etc.
[quoted text clipped - 4 lines]
>
>Can anyone help ? Thanks.

Reply to this Message