How to filter ODD number separately

• For filtering ODD number from a list use the below mentioned Formula

• (=ODD)

• Select the number list (Column)

• Now the ODD numbers has been filtered

• Use paste special for numerical usage and Remove the duplicates

• We can also get the Even numbers in next column