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 |
#2
|
|||
|
|||
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 "nicad_adam" wrote in message ... 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 |
#3
|
|||
|
|||
Hi Jim, Thanks for that...... works like a dream Cheers, 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 |
Reply |
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 |