I need to split a column of numbers into odd or even

I have a column of number such as 1
2
2
3
5
5
6
7
7
7
7
9
9
10
10
11
11
15
15
15
16
17
17 and I wish to sort them into odds and evens but I can not get started help does not give me the answer I need, I am sure that it is a very easy task but getting my 62 year old brain around it is just not happening.

Thanks Stuart

Sheesh, the younger generation these days :slight_smile:

IF and MOD are functions that might fit your needs - see the attached sample file for one way of doing it.

oddeven.ods

From there you could filter, sort etc as you need.

Cheers from someone 10 years your senior.

If this answer helped you, please accept it by clicking the check mark :heavy_check_mark: to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

Thanks it works, now with more time on my hands I will be able to learn more about Functions

Stuart