Home > IT Answers > Microsoft Windows > Excel 2007 – How to find duplicate data and sort into a row
Miya
30 pts.
 Excel 2007 – How to find duplicate data and sort into a row
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

Software/Hardware used:
ASKED: April 21, 2009  6:39 AM
UPDATED: April 21, 2009  11:49 PM
RELATED QUESTIONS
Answer Wiki:
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.
Last Wiki Answer Submitted:  April 21, 2009  7:30 am  by  mshen   27,310 pts.
All Answer Wiki Contributors:  mshen   27,310 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

SbElectric
 2,510 pts.
 

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.

Miya
 30 pts.