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
--
nicad_adam
------------------------------------------------------------------------
nicad_adam's Profile:
http://www.excelforum.com/member.php...o&userid=24178
View this thread:
http://www.excelforum.com/showthread...hreadid=378000