Creating new worksheet from existing

[Guest]

I would like to create a worksheet with unique values (rows of data, records)
only from a worksheet which contains rows with multiple values. There is an
identifier at the beginning of each row, I only want to see each identifier
1x in the new table. Help is appreciated.

 

[Tom Ogilvy]

See Chip Pearson's page on working with duplicates and uniques:

http://www.cpearson.com/excel/duplicat.htm

 

[Gord Dibben]

ddpen

Debra Dalgleish has instructions for extracting uniquw data to another
worksheet.

http://www.contextures.on.ca/xladvfilter01.html#ExtractWs

Gord Dibben Excel MVP