Hi Valko,

You are spot on! yes this is exactly what I am doing now as shown in Sheet 1 above.

I use Excel 2007

thanks in advance,

Karnik

With the numbers in the range A1:E1...

For the even numbers...

Enter this array formula** in G1 and copy across to K1:

=IFERROR(INDEX(1:1,SMALL(IF(ISNUMBER($A1:$E1),IF(MOD($A1:$E1,2)=0,COLUMN($A1:$E1))),COLUMNS($G1:G1))),"")

For the odd numbers...

Enter this array formula** in M1 and copy across to Q1:

=IFERROR(INDEX(1:1,SMALL(IF(ISNUMBER($A1:$E1),IF(MOD($A1:$E1,2)>0,COLUMN($A1:$E1))),COLUMNS($M1:M1))),"")

** array formulas need to be entered using the key

combination of CTRL,SHIFT,ENTER (not just ENTER).

Hold down both the CTRL key and the SHIFT key

then hit ENTER.