Hi
Look at the function ISODD
For eg if list is in column A put the following formula in
column b and drag down.
=isodd(a1)
And then sort by column B
Hope this helps
Can someone tell me how to sort a column by if a number is odd or even. I would guess that I would need to use a function in another column and first designate if the number is even or odd. Can someone please tell me what function this is ...
Results 1 to 11 of 11
Can someone tell me how to sort a column by if a number
is odd or even. I would guess that I would need to use a
function in another column and first designate if the
number is even or odd. Can someone please tell me what
function this is or how to do this? Thanks in advance.
Hi
Look at the function ISODD
For eg if list is in column A put the following formula in
column b and drag down.
=isodd(a1)
And then sort by column B
Hope this helps
Hi
one way: add the following function in the adjacent column:
=IF(MOD(A1,2)=1,"Odd","Even")
copy down and sort with this column
--
Regards
Frank Kabel
Frankfurt, Germany
Holstein wrote:
Thank you both for your help. It works great. Thank you
again for your help. I appreciate it very much.
column:
a
Frank
Can you tell me what this function is doing. I understand
that the A1 is the column with the number. What does MOD
do and what is the 2 and the =1? It works great but I'm
trying to learn as much as I can. Thanks again.
column:
a
Hi
Mod returns the rest of a division. So in your case the cell A1 is
divided by two and the rest of this division is returned. e.g.
MOD(4,2) = 0
MOD(5,2) = 1
--
Regards
Frank Kabel
Frankfurt, Germany
microsoft.com wrote:
Holstein
If you check the ysis Toolpak in Tools>Add-ins you can use either the
ISODD or ISEVEN function to return TRUE or FALSE in an adjacent column.
Sort or Filter on this column.
Assume column of numbers is A.
In B1 enter =ISODD(A1) and drag/copy down or double-click on B1 to copy down.
Gord Dibben Excel MVP
On Wed, 25 Feb 2004 09:03:18 -0800, "Holstein"
<microsoft.com> wrote:
=MOD({cell-of-interest},2)=0 will give TRUE for even and FALSE for odd.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <167d01c3fbc1$442a0410$gbl>,
microsoft.com says...
Hi Tushar!
=MOD(INT(MyCell),2)=0
tes the ysis Toolpak ISEVEN treatment of non integers.
But I'm inclined to prefer a FALSE response for numbers that are not exact
integers.
--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Tushar Mehta" <SeeOhEm> wrote in message
news:..
Hi Norman,
After a while, one either forgets or just gets sloppy. My intuitive
reaction to odd/even is to test for divisibility by 2. Though,
strictly speaking, it applies only to whole numbers, doesn't it?
The ATP is amazing. The more I learn about it the more I appreciate my
decision to minimize my reliance on it.
In any case, if one wanted to duplicate the ISEVEN functionality one
should TRUNC rather than INT. There's a difference when dealing with
negative numbers.
So, I guess a strict test for even would be
=IF(INT(X)<>X,NA(),MOD(X,2)=0)
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <e1t19sA$phx.gbl>,
com.au says...
Hi Tushar!
Agreed on your revised version.
Also agreed on the minimization of reliance on ysis ToolPak.
I'm not sure how mathematicians view it, but there is a possibility
that 1.1 should return FALSE rather than #NA!
Those ATP functions are due for a 10000 mile service.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Tushar Mehta" <SeeOhEm> wrote in
message news:..
my
with
not exact