Excel 2007 – How to find duplicate data and sort into a row

30 pts.
Tags:
Excel 2007
Microsoft Excel 2007
Microsoft Excel 2007 macros
I have two column. I would like to find the duplicate data and sort the int a row. Eg: Name Name2 Julie Jane Sally John Jack Paul Jane Sally The result: Name Name Julie Sally Sally Jack Jane Jane John Paul Pls help

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can make a macro to do that, but it would be easier if you just cut and paste the second column to the end of the first then highlight the column and click on the sort button.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • SbElectric
    Here is step-by-step on excel 2007 Let us say B1 has Name and C1 is Name2 B2 thru B5 contain one list & C2 thru C5 contain 2nd list Copy the content of C2 thru C5 (Ctrl+C & Ctrl+V) on B6; (Press Esc key to get rid of the dotted line) Now highlight B2 thru C9 & sort (A to Z); You will notice all names including the duplicates If you want to get rid of the duplicates - Pres Data Tab on the Top Row Highlight B2 to B9 & then hit Remove Duplicates - Select Continue with current selection. Hopefully you will see the names (without the duplicates) in ascending order.
    2,540 pointsBadges:
    report
  • Miya
    Actually the result that i want is like this: The result: Name Name2 Julie Sally Sally Jack Jane Jane John Paul I would like the Name2 column match with the Name column.
    30 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following