Excel Sort
 

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

Excel Sort
 

=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

Excel Sort
 

Try this:

data - is a defined name range

odd values:
In B2:
=IF(ISERR(SMALL(IF(MOD(data,2)=1,ROW(INDIRECT("1:" &ROWS(data)))),ROWS($1:1))),"",INDEX(data,SMALL(IF (MOD(data,2)=1,ROW(INDIRECT("1:"&ROWS(data)))),ROW S($1:1))))

even values
In C2:
=IF(ISERR(SMALL(IF(MOD(data,2)=0,ROW(INDIRECT("1:" &ROWS(data)))),ROWS($1:1))),"",INDEX(data,SMALL(IF (MOD(data,2)=0,ROW(INDIRECT("1:"&ROWS(data)))),ROW S($1:1))))

Both formulae are required Ctrl+Shift+Enter, not just Enter
copy down as far as needed


"Templar" wrote:

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

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

Excel Sort
 

Yes, absolutely right.
--
David Biddulph

"Teethless mama" wrote in message
...
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