Filter Question

[Guest]

Is there a way to filter out duplicating items? For instance: I have a
series of rows for shipping transfer information


Column 1 Column 2 column 3
Warehouse Warehouse Part Number
1D 2D AR50041
1D 2D AR50041
1D 2D TI9871


I want to get rid of the single ones in the column 3. I am looking to get
all the duplicates illustrated. Make Sense? So I am trying to filter the
whole document so that only part numbers that have been transfered more than
once are shown. Thanks!!!!

 

[Bob Phillips]

Add a helper column and a formula in D2 of

=C2=C1

copy that down, filter column D by the TRUE value, and delete the visible
rows

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)