J
johnrambo
Any ideas how to sort a column of figures so as to
separate odd numbers from even?
separate odd numbers from even?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Norman Harker
Hi johnrambo!
You could add a helper column and use the ISODD or ISEVEN function
from the Analysis ToolPak and then sort with the criteria from that
column. Ascending gives FALSE first and then TRUE
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
You could add a helper column and use the ISODD or ISEVEN function
from the Analysis ToolPak and then sort with the criteria from that
column. Ascending gives FALSE first and then TRUE
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
F
Frank Kabel
Hi
insert a helper column (lets say B) and insert the following formula in
B1
=MOD(A1,2) ->
copy down and sort by column B
Frank
insert a helper column (lets say B) and insert the following formula in
B1
=MOD(A1,2) ->
copy down and sort by column B
Frank
P
Peo Sjoblom
If you don't have the ATP you can use
=MOD(A2,2)=1
will return true for odd integers
=MOD(A2,2)=1
will return true for odd integers
J
johnrambo
Cheers - this works fine! Just what I needed - thanks for the help.