move unique data to new column

therrin

Estimable
Mar 5, 2015
2
0
4,510
0
Hello,
I have 2 columns each containing the following:

Row 1 Row 2
1 1
2 2
3 3
4 5
6 7
8 8
9 9
10 10
11 12
13 14
15 15
16 16
17 17
18 18
19 20
21 22
23 23
24 24
25 25

How do I move the cells that contain ONLY "individual" data. I would want the answer to be:

Only the Unique Data
4
5
6
7
11
12
13
14
19
20
21
22
(I did this manually - I have lists in the thousands).

Thank you in advance any and all help!!!
Terri
 

therrin

Estimable
Mar 5, 2015
2
0
4,510
0
I'm not the greatest at this... there are no conditions except the following

If you look through the 2 columns, you will see .... 4 5 6 7 11 12 13 14 19 20 21 & 22 only show up one time in either column.

I need ONLY the unique data - regardless of which column it's in - to be moved over to a new column by itself.

I hope I'm explaining this clearly! :(


I'm using Excel 2010 in Windows 7 desktop
 

ASK THE COMMUNITY

TRENDING THREADS