Home |
Search |
Today's Posts |
#1
|
|||
|
|||
I need to find odd numbers in a column
I have a large excel spreadsheet that I need to find either all even numbers
or all odd numbers in a column. IIs there a simple function for doing this? |
#2
|
|||
|
|||
With values in col. A, put this in B1 and fill down:
=IF(ISODD(A1),"Odd","Even") HTH Jason Atlanta, GA -----Original Message----- I have a large excel spreadsheet that I need to find either all even numbers or all odd numbers in a column. IIs there a simple function for doing this? . |
#3
|
|||
|
|||
=MOD(A1,2) will return 0 for even numbers, 1 for odd numbers.
On Thu, 27 Jan 2005 05:41:04 -0800, "whouser" wrote: I have a large excel spreadsheet that I need to find either all even numbers or all odd numbers in a column. IIs there a simple function for doing this? |
#4
|
|||
|
|||
Note: the Analysis ToolPak add-in must be loaded to access the ISODD or
ISEVEN Functions. ToolsAdd-insATP checked. Gord Dibben Excel MVP On Thu, 27 Jan 2005 05:58:06 -0800, "Jason Morin" wrote: With values in col. A, put this in B1 and fill down: =IF(ISODD(A1),"Odd","Even") HTH Jason Atlanta, GA -----Original Message----- I have a large excel spreadsheet that I need to find either all even numbers or all odd numbers in a column. IIs there a simple function for doing this? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
How can you find duplicate numbers in a column? | Excel Worksheet Functions | |||
find first nonzero value in column | Excel Worksheet Functions | |||
find first nonzero value in column | Excel Worksheet Functions | |||
find first nonzero value in column | Excel Worksheet Functions |