Sorting lists to remove double entries

N

nicad_adam

Hi all,

I am trying to transfer clients from one sheet whose name appears only
once in a list onto a new sheet.

For example:

Sheet1:

Seminar Type | Surname | First Name
---------------------------------------------------
Sem1 Smith Adam
Sem2 Smith Adam
Sem2 Jones Mary

What I want to do is put on a new sheet only those clients who have
been to only one seminar type ie Mary Jones.

Any help would be greatly appreciated

Thanks,

Adam
 
J

Jim May

Temporarily add Col D and Col E (In sheet1) and where

A B C
D E
Row2 Sem1 Smith Adam =B2&C2
=IF(SUM(1/COUNTIF($D$2:$D$11,$D$2:$D11))=1,"Single-Attendance","")

Copy down D2 and E2 down to last of your records (I assumed to row 11
<<Change to yourspecs)..

At this point Use the Auto-Filter to select on Col E for
"Single-Attendance" - only those should the show; Highlight filtered range
and Copy, then Paste to New sheet.

Try this on a BACKUP COpy Only !!!
HTH
 
Top