odd and even numbers

  • Thread starter Thread starter johnrambo
  • Start date Start date
J

johnrambo

Any ideas how to sort a column of figures so as to
separate odd numbers from even?
 
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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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
 
If you don't have the ATP you can use

=MOD(A2,2)=1

will return true for odd integers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Odd and even numbers 6
Countif function for Even and Odd numbers 34
odd and even addresses 3
Why Excel Does not increment by 2 or 3, odd/even numbers? 6
how can i sort on a perticular column for odd and even numbers 3
Function for odd even numbers 4
EXCEL FUNCTIONS 1
Sort by even and odd digits and copy to separate worksheet 3

Back
Top