Formula to display Odd/Even pattern

[b_rianv]

I am using excel 2010 and I would like to have a formula to do a "odd/even" pattern for my lottery numbers in a row.
Example...
Cells C1:H1 have my lottery drawn numbers (1,2,3,4,5,6) now in cell K1 I would like to see the even/odd pattern like this "OEOEOE" to display. How would I do this??

I am trying to use this formula but it's not working....=IF(ISEVEN(HLOOKUP(C1:H2,2,0)),"E","O").
I am getting errors like...#NA or #VALUE or nothing shows up. I am entering it as a array

Does any one know a formula on how to do this??

Any help would be great

Thanks,

[cbatrody]

Hi,

Please try the following formula in K1

=IF(ISODD(C1),"O","E")&IF(ISODD(D1),"O","E")&IF(ISODD(E1),"O","E")&IF(ISODD(F1),"O","E")&IF(ISODD(G1),"O","E")&IF(ISODD(H1),"O","E")

[Zodeeak]

=CONCATENATE(IF(A1/2=INT(A1/2),"E","O"),IF(B1/2=INT(B1/2),"E","O"),etc. is one way to do it.

Hope that helps.

-Z

[b_rianv]

Thanks guys both of these formulas work GREAT!!!

Thank you

[cbatrody]

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.

[Tony Valko]

Another possibility that uses a VBA function.

With your file open...

Press the key combination of Alt+F11 to open the Visual Basic Editor

Goto the menu Insert > Module

Copy the VBA code at this link and paste it into the window that opens on the right side of the screen

Press the key combination of ALT+Q to close the Visual Basic Editor and return to Excel.

Data Range

	C	D	E	F	G	H	I	J	K
1	6	11	15	21	28	35			EOOOEO
2	------	------	------	------	------	------	------	------	------

Enter this array formula** in K1:

=concatall(IF(MOD(C1:H1,2),"O","E"))

** 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.

[b_rianv]

Mr. Valko,

I am interested in using the VBA code you have directed me too BUT there are a lot of those VBA code to do what I want to do with my number pattern. Can you tell me which one I should look in to?

Thank you

[Tony Valko]

Use the one I linked to.

It should take you to post #8 in the thread. Use the code in post #8.

[b_rianv]

Thank you I will look at it. But I have kind of found a working macro BUT it not only copies my formulas over ,it also copies the values and I am trying to figure out how too stop it from bring out the cell value. Can you take a look??

Sub Insert2()
 'copy formula from cell H3 to cell H2
 Range("H2").Formula = Range("H3").Formula
 'copy formula from cell I3 to cell I2
 Range("I2").Formula = Range("I3").Formula
 End Sub

Any help would be great

Thank you

[Tony Valko]

I'm not much of a programmer.

I can copy and use someone else's code but I can't write code myself.