Eliminating even or odd numbers

[khank]

In separate columns I am trying to eliminate either all "EVEN" or all "ODD" numbers.

See sample –

The coding I'm using is:

ODD
=IF($J$1="ODD",IF(A2="","",IF(MOD(A1,2)=0,A2,"")),A2)

EVEN
=IF($N$1="EVEN",IF(A2="","",IF(MOD(A1,2)=1,A2,"")),A2)

When I first look the coding appeared to work, but on second glance it obviously wasn't.

[ChemistB]

For the first column
=IF($C$1="ODD",IF(A2="","",IF(MOD(A2,2)=1,A2,"")),A2) although since you know C1 = ODD, you can shorten that to
IF(A2="","",IF(MOD(A2,2)=1,A2,""))

For the Even Column
=IF($E$1="EVEN",IF(A2="","",IF(MOD(A2,2)=0,A2,"")),A2)
or
=IF(A2="","",IF(MOD(A2,2)=0,A2,""))
Does that work for you?

[NBVC]

Try:

=IF($C$1="ODD",IF(A2="","",IF(SUMPRODUCT(--(LEN(A2)-LEN(SUBSTITUTE(A2,{1,3,5,7,9},""))))>=2,A2,"")),A2)

and

=IF($E$1="EVEN",IF(A2="","",IF(SUMPRODUCT(--(LEN(A2)-LEN(SUBSTITUTE(A2,{0,2,4,6,8},""))))>=2,A2,"")),A2)

[martindwilson]

try for odd =IF(--ISODD(LEFT(A2))+(--ISODD(MID(A2,2,1)))+(--ISODD(RIGHT(A2)))>1,A2,"")
or =IF(SUM(--ISODD(LEFT(A2)),(--ISODD(MID(A2,2,1))),(--ISODD(RIGHT(A2))))>1,A2,"")

for even
=IF(--ISODD(LEFT(A2))+(--ISODD(MID(A2,2,1)))+(--ISODD(RIGHT(A2)))>1,"",a2)
or
=IF(SUM(--ISODD(LEFT(A2)),(--ISODD(MID(A2,2,1))),(--ISODD(RIGHT(A2))))>1,"",a2)

[khank]

Everyone thanks for your help.

So many solutions.

I've attached an updated sample.

[DonkeyOte]

Yet another alternative:

Please Login or Register  to view this content.

the above could be applied to both columns simultaneously (no need for modification)

[khank]

That also works. Thanks. Now I'm playing around with eliminating all repeat digit numbers from the ODD and EVEN columns - 551, 889, etc.