Scan column for first of a list
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. |
Scan column for first of a list
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. |
All times are GMT +1. The time now is 06:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com