Using ISODD function in Excel 2010, you can categorize numeric values into Even & Odd groups. It returns True in an event of finding Odd number and conversely is the case with finding a even number.
You can also enter direct values in argument but we will be specifying location of the cells. The syntax goes like this;
Drag the plus sign at the end of the cell to the bottom for applying the formula over the column.