Hello everyone,
Can someone help me with this case? In col A I have the numbers 1-30.
I would like to have all the unique even numbers in col D, and all the unique uneven numbers in col F.
The numbers in col A can be much more.
Thanks in advance!
Can someone help me with this case? In col A I have the numbers 1-30.
I would like to have all the unique even numbers in col D, and all the unique uneven numbers in col F.
The numbers in col A can be much more.
Thanks in advance!
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | 1 | 2 | 1 | |||||
2 | 2 | 4 | 3 | |||||
3 | 3 | 6 | 5 | |||||
4 | 4 | 8 | 7 | |||||
5 | 5 | 10 | 9 | |||||
6 | 6 | 12 | 11 | |||||
7 | 7 | 14 | 13 | |||||
8 | 8 | 16 | 15 | |||||
9 | 9 | 18 | 17 | |||||
10 | 10 | 20 | 19 | |||||
11 | 11 | 22 | 21 | |||||
12 | 12 | 24 | 23 | |||||
13 | 13 | 26 | 25 | |||||
14 | 14 | 28 | 27 | |||||
15 | 15 | 30 | 29 | |||||
16 | 16 | |||||||
17 | 17 | |||||||
18 | 18 | |||||||
19 | 19 | |||||||
20 | 20 | |||||||
21 | 21 | |||||||
22 | 22 | |||||||
23 | 23 | |||||||
24 | 24 | |||||||
25 | 25 | |||||||
26 | 26 | |||||||
27 | 27 | |||||||
28 | 28 | |||||||
29 | 29 | |||||||
30 | 30 | |||||||
Sheet1 |