Hi
I have a spreadsheet with addresses on and need to format the numbers in order as below. I need to seperate them by odds and evens as well
I have a list as below
42A
40
39
39a
38A
37A
35
35A
31A
30A
29A
and I need them to be in some seperate order like below
all the odds from 42A, 40, 38A 30a ETC..
all the same with the ODDS s from 2a to 42a
I dont want the odds and evens together
Any help to a novice is much appreciated
Example sheet attached
Bookmarks