We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

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

asked 2018-02-18 06:32:55 +0200

stuarts.burgers gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-30 17:41:35.533587

1 Answer

Sort by » oldest newest most voted

answered 2018-02-18 07:14:02 +0200

robleyd gravatar image

Sheesh, the younger generation these days :-)

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


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

edit flag offensive delete link more



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


stuarts.burgers gravatar imagestuarts.burgers ( 2018-02-18 17:44:16 +0200 )edit

Question Tools

1 follower


Asked: 2018-02-18 06:32:55 +0200

Seen: 1,014 times

Last updated: Feb 18 '18