I can for example use DATA - REMOVE DUPLICATES in column B, but what do I do if I at the very same time I'd like to keep the duplicates of column B if the data is unequal in column L - Then how do I do it?
I tried a nested loop in VBA, but too much data for it. takes forever and ever to run it. Had to use CTRL-Break on it.
So... Anyone..?? :O)
Amatør,
here's a trick I use to move all duplicate values in a column to the bottom. See if it works for you.
if your data is in column A, first, sort the data in column A by value.
Then in column B (or any blank column), label the duplicate values in column A by using the following formula. Start in B1 and go down all the way:
Then copy column B and paste it back as "Values", i.e. Paste Special --> Values.=if(A1=A2,"Duplicate","")
Now sort the data in columns A and B based on the values in column B. This should move all the duplicate values to the bottom of the column and you can get rid of column B.
Let me know if you have any luck with this.
Cheers
<-- If you're happy & you know it...click the star.:-)
Yes, SMART! Thank you very, very much! :O)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks