daveyb
Member
Registered: 5th Nov 02
User status: Offline
|
I've got a spreadsheet with over 4000 rows of information.
It's a list of people with one column that uniquely identifies them, however because of other information in the sheet some are duplicated
I need to keep all the people who are duplicated, and get rid of those with single entries.
Is there a quick way to do this or do i have to get someone to go through them all?
Work have done it before by sorting by the unique identifier, scrolling down the list and deleting the single entries - i don't fancy that job!
Cheers.
|
paul.mitchell1984
Member
Registered: 31st Aug 06
Location: Wakefield
User status: Offline
|
could you not arrange by name or create lists, may make it easier, but no real way to filter out the "seperate ones"
|
Robbo
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
Sort by the duplicated column then mock up a yes/no if formula where if (say) b1=a1 then the answer is yes
Copy and paste special values the if formulas and sort by yes/no, delete the yes's... da daaa... I do this everyday, simple but effective
|
daveyb
Member
Registered: 5th Nov 02
User status: Offline
|
Robbo, you're a hero!
|
Robbo
Member
Registered: 6th Aug 02
Location: London
User status: Offline
|
Np mate, sometimes the simple things work the best
|