Return unique numbers by even or uneven filter

[CV12]

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!

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

 

[kevin9999]

In D1 put: =UNIQUE(FILTER(A:A,(MOD(A:A,2)=0),""))

In F1 put: =UNIQUE(FILTER(A:A,(MOD(A:A,2)=1),""))

 

[CV12]

Thanks Kevin

 

[kevin9999]

Thanks Kevin

You're welcome and thanks for the feedback ?

 

[CV12]

Kevin,

Can you help me one more time with this formula?

In D1 put: =UNIQUE(FILTER(A:A,(MOD(A:A,2)=0),""))

I can't get to remove the last zero in the column. Why doesn't <> work after the A:A?

 

[kevin9999]

Kevin,

Can you help me one more time with this formula?

In D1 put: =UNIQUE(FILTER(A:A,(MOD(A:A,2)=0),""))

I can't get to remove the last zero in the column. Why doesn't <> work after the A:A?

Try this

In D1: =UNIQUE(FILTER(I:I,(MOD(I:I,2)=0)*(I:I<>""),""))

In F1: =UNIQUE(FILTER(I:I,(MOD(I:I,2)=1)*(I:I<>""),""))

 

[CV12]

Thanks alot

 

[CV12]

Kevin,

Would there be a way to reverse the numbering? So that it starts with the highest number and goes down?

 

[kevin9999]

Yes, but I won't get to my laptop for a few hours.

 

[kevin9999]

To sort them with the highest number on top, descending downwards

In D1: =SORT(UNIQUE(FILTER(A:A,(MOD(A:A,2)=0)*(A:A<>""),"")),,-1)

In F1: =SORT(UNIQUE(FILTER(A:A,(MOD(A:A,2)=1)*(A:A<>""),"")),,-1)

To change the sort order to Ascending (smallest on top) simply change the last bit -1) to 1) (lose the minus sign)