I am having an excel sheet in which there is a column having duplicate values. I want to remove duplicates from it. There is a direct option of "removing duplicates" in Excel 2007 but when I use it, it automatically sorts the whole list (after removing duplicates). But I do not want it to be sorted. Is there any way out?
1 way woud be to add a helper column and number it starting at 1, down to the bottom of your data. when you do the "sort" and rempve the duplicates, rsort based onthat new column to get it back in the original order...then delete the numbers
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
You can use MATCH function.
ex. =MATCH(A1;$B$1:$B$15;0)
You have the A&B columns that you want to compare. You write down the function in the C column and you drug it down till the end of last data of column A. The function returns you either a number (that shows you the dublicates) or N/A. You filter the list by the number and you delete the rows
Last edited by johnnylzep; 06-14-2012 at 03:13 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks