I need to find odd numbers in a column

W

whouser

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?
 
J

Jason Morin

With values in col. A, put this in B1 and fill down:

=IF(ISODD(A1),"Odd","Even")

HTH
Jason
Atlanta, GA
 
G

Gord Dibben

Note: the Analysis ToolPak add-in must be loaded to access the ISODD or
ISEVEN Functions.

Tools>Add-ins>ATP checked.


Gord Dibben Excel MVP
 
Top