Removing duplicate entries

[Guest]

I have a spreadsheet with 3 columns; Name, Company & email address. I have
discovered that some of these rows (records) have been duplicated. Is there
a way I can remove just the rows of data where all the information in the 3
columns has been duplicated?

Thanks for any help

 

[Jim Cone]

Check out what Chip Pearson has to say here...
http://www.cpearson.com/excel/duplicat.htm
I don't believe there is an answer there that exactly meets your needs
but there are some good techniques that you can possibly modify.

--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel add-ins)



"Roger Bell" <[email protected]>
wrote in message
I have a spreadsheet with 3 columns; Name, Company & email address. I have
discovered that some of these rows (records) have been duplicated. Is there
a way I can remove just the rows of data where all the information in the 3
columns has been duplicated?

Thanks for any help

 

[Guest]

Here's one way using non-array formulas to directly extract the list of
unique lines

Source data is assumed within cols A to C, data from row2 down

Put in D2
=IF(COUNTA(A2:C2)<3,"",IF(SUMPRODUCT((A$2:A2=A2)*(B$2:B2=B2)*(C$2:C2=C2))>1,"",ROW()))
Leave D1 blank

Put in E2:
=IF(ROWS($1:1)>COUNT($D:$D),"",INDEX(A:A,SMALL($D:$D,ROWS($1:1))))
Copy E2 to G2. Select D2:G2, copy down to cover the max expected extent of
data in the source cols A to C, say down to G100? Hide away col D. Cols E to
G will return the required list of unique lines, with results all neatly
gathered at the top.