repeated data

[vince]

I have a worksheet that has rpeated data i would only like
to see each part # once how would i do that?

Vince

 

[Gord Dibben]

Vince

You can use Data>Filter>Advanced Filter.

"Copy to a new location" and "Unique records only"

Filtering Tutorial at Debra Dalgleish's site.......
http://www.contextures.on.ca/tiptech.html

Also check out Debra's info on Data Validation........
http://www.contextures.on.ca/xlDataVal01.html

More on Duplicates marking, preventing at Chip Pearson's site....
http://www.cpearson.com/excel/topic.htm

Scroll down to "D" section and select Duplicate topics.

Gord Dibben Excel MVP