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? |
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? . |
=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? |
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? . |
All times are GMT +1. The time now is 03:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com