Excel Sort
Your formulae don't work
=IF(MOD(A2),A2,"") in the odd column
=IF(MOD(A2),"",A2) in the even column
try like this:
=IF(MOD(A2,2),A2,"")
=IF(MOD(A2,2),"",A2)
"David Biddulph" wrote:
=IF(MOD(A2),A2,"") in the odd column
=IF(MOD(A2),"",A2) in the even column
--
David Biddulph
"Templar" wrote in message
...
I have a column of odd and even numbers and would like to move numbers
ending in a odd number to one column and those ending in an even number in
a separate column. Could you expain how I might do that?
Thank you.
1800
1801
1802
1803
1805
1805
1807
1808
1809
1806
1806
1806
1808
1811
1811
--
Templar
|