View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Meebers Meebers is offline
external usenet poster
 
Posts: 80
Default Sorting in Excel

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