Can anyone please explain how the following was done. I'm unsure whether a simple formula or excels standard functions were used.
Before: Random Data Clense _Master sheet2.xlsx (20.0 KB) (attached)
The spreadsheet needed to be cleaned of duplicates but the extra column had to contain the unique IDs of duplicates removed.
After: Random Data Clense _Master sheet2_halfdone.xlsx (16.5 KB) (attached)
Thanks in advance!
Last edited by dylanpp; 07-12-2011 at 12:46 PM.
I desperately need to know this by tomorrow for an interview! I'd be grateful for any help on the matter.
Dylan
Your post does not comply with Rule 9 of our Forum RULES. If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit. And please never edit a thread in which someone else has responded.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks