Sorting in Excel
Should have been "ISEVEN" ...what you asked for.
"Meebers" wrote in message
...
How about the formula "ISODD". Filter by "true"
"Aqib Rizvi" wrote in message
...
If you need only to 'identify' odd numbers, then another way could be
to use Format, Conditional Formatting,
HIghlight your column (say A5 to A30). In Condition 1, choose
Forumula Is and type =MOD(A5,2)=0 and define what sort of
Identification you want.
This would not require any sorting.
AQIB RIZVI
|