Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sorting lists to remove double entries
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I search a mailing list spreadsheet to remove entries alre. | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
Remove link fr a column of entries | Excel Discussion (Misc queries) | |||
count data but avoid double entries | Excel Worksheet Functions |