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
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