Ask Your Question
1

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

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 close merge delete

1 Answer

Sort by » oldest newest most voted
2

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.

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

Comments

1

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

Stuart

stuarts.burgers gravatar imagestuarts.burgers ( 2018-02-18 17:44:16 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 398 times

Last updated: Feb 18 '18