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
Last edited by Quicksand10; 07-30-2010 at 05:12 PM. Reason: header crow lol
Welcome to the forum.
Add a header row above the data.
Last edited by shg; 07-30-2010 at 05:12 PM. Reason: Lose the crow, add the row ... :)
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
caw caw lol
or =COUNTIF($A$1:A1,A1)<COUNTIF(A:A,A1) delete true
Last edited by martindwilson; 07-30-2010 at 05:12 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks