Thread: dublication
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max
 
Posts: n/a
Default dublication

"Karl" wrote
is there a way to hide dublications in a column
where the information the following columns may be different?


One guess .. and play ..

Assume items are listed in col A, from A2 down
(A1 contains the label)

Put in B2:
=IF(A2="","",IF(COUNTIF($A$2:A2,A2)1,"Duplicate", "Unique"))
Copy B2 down until the last row of data in col A

Select B1, click Data Filter Autofilter

To hide the duplicates in col A: just select "Unique" from the droplist in
B1
And the other way, if required: To hide uniques, just select "Duplicate"

(The filtered rows gives the result of the selections from the autofilter
droplist)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---