Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Duplicate entries in excel spreadsheet
I have lists of attendees to an annual event. I've taken the lists and
combined them, and sorted them by first and last name alpha. I want to keep the names and corresponding collumns for those that attended my event more than once and dump the rest. Is there a way to sort them quickly as i have over 15,000 names. Cheers! |
#2
|
|||
|
|||
I'd insert two new columns before the list, say A and B. In the first data
row in B, say B2, I'd enter a formula that combines the first and last names to create a field the uniquely identifies each record: =C2&D2 and copy it down to all records. Next in A2 enter this formula: =IF(B2=B1,A1+1,1) and copy it down. Change Calc mode to Manual if it's not. Then sort by column A. All the "2"s are the records you want. Select the range from the first 2 to the last, copy, and paste it in a new sheet. -- Jim "Coldsplice" wrote in message ... |I have lists of attendees to an annual event. I've taken the lists and | combined them, and sorted them by first and last name alpha. I want to keep | the names and corresponding collumns for those that attended my event more | than once and dump the rest. Is there a way to sort them quickly as i have | over 15,000 names. | Cheers! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
identify duplicate data in excel spreadsheet | Excel Discussion (Misc queries) | |||
Send Excel 2002 spreadsheet to MacIntosh Excel 2004 | Excel Discussion (Misc queries) | |||
How can I purge duplicate entries in Excel | Excel Discussion (Misc queries) | |||
Duplicate records in Excel | Excel Discussion (Misc queries) | |||
Copying an Excel spreadsheet to a Word document | Excel Discussion (Misc queries) |