Hey guys, I'm new to these forums. I searched the forums and didn't exactly find what I needed...
Today I was working on some excel spreadsheets and I needed to find and delete duplicates. But Excel 2007 (for some reason) is only able to delete the second duplicate it finds...
For example, if I had:
FILE # VALUE
0930809 2009
0930809 2839
3994843 4857
it would always delete the second entry,
0930809 2839
Is it possible to have it delete the first entry, and not the second one?
I tried sorting it out the opposite way (I had it from smallest to biggest) and it would still remove the wrong duplicate.
Ideas?
Right now I used a formula and copied it all the way down to at least spot the duplicates,
=IF(OR($A3=$A4,$A3=$A2),"same","")
and I'm going manually to remove them. It's getting long though and I have many more to go through.
Thanks a lot,
Quicksand10
Bookmarks