LinkBack URL
About LinkBacks
How can I remove duplicate rows? I know there is a conditional way to mark it, but I want to do the following.
First Last Raw
Jim Ray
Jim Ray
John Doe
John Doe
First Last Results
Jim Ray
John Doe
Thank you.
How can I remove duplicate rows? I know there is a conditional way to mark it, but I want to do the following.
First Last Raw
Jim Ray
Jim Ray
John Doe
John Doe
First Last Results
Jim Ray
John Doe
Thank you.
Maybe..
Select Range---> Go to Data--->Remove duplicates
Life's a spreadsheet, Excel!
Say thanks, Click *
Have you tried the remove duplicates option in excel 2007? Go to Data -> Remove Duplicates.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Arlette mentioned the easiest way but if you want code to do it, you can use this..
Please Login or Register to view this content.
Heres just another code example to delete all rows at once. Faster then deleting one row at a time
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks