V vince Aug 25, 2004 #1 I have a worksheet that has rpeated data i would only like to see each part # once how would i do that? Vince
I have a worksheet that has rpeated data i would only like to see each part # once how would i do that? Vince
G Gord Dibben Aug 25, 2004 #2 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
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
