How can I filter ofr odd and even values

D

Diana

Hi,

Can I filter Odd and even values in Excel.Is there any formula,
function or filter?

Thanks and Merry Christmas to all
 
H

Harald Staff

Easiest is to use a helper column with a formula like
=MOD(A2,2)

HTH. Best wishes Harald
 
Top