How can I filter ofr odd and even values

  • Thread starter Thread starter Diana
  • Start date Start date
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
 
Easiest is to use a helper column with a formula like
=MOD(A2,2)

HTH. Best wishes Harald
 
Back
Top