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 
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.
Thanks it works, now with more time on my hands I will be able to learn more about Functions
Stuart