Excel formula help for repeat , +1 , +2 and -1 , -2.

Reply #4

frenchie — Tue, 13 Jul 2010 09:52:16 GMT

Hello Raven62,

I should have had asked on the first post but I forgot.

What would be the formulas to do the same thing but in the conditioal formatting ? to highlight the numbers in the new draw when they match the criteria ?

Thank you Raven62

Reply #3

frenchie — Mon, 12 Jul 2010 09:16:45 GMT

Raven62,

Thank you very much those work perfect.

Serge.

Reply #2

Raven62 — Sat, 10 Jul 2010 22:36:10 GMT

I2 thru M2 =(IF(COUNTIF($C1:$G1,C2)=1,C2, )

O2 thru S2 =(IF(COUNTIF($C1:$G1,C2-1)=1,C2,

Reply #1

frenchie — Sat, 10 Jul 2010 18:43:32 GMT

No one can't help I'm surprise !!! with all the GURUS in Excel on this LP !!!, it would be hightly appreciated, we all have the same goal here to find a way to hit the right numbers.

Thanks.

Excel formula help for repeat , +1 , +2 and -1 , -2.

frenchie — Wed, 07 Jul 2010 21:44:00 GMT

Hi,

I'm looking for someone to help me with thoses formulas, thank you ?

My data are for 5/56 and from C1 to G1 going down.

1) I need formulas that will return the repeat numbers from only the previous combination draw but NOT FROM THE POSITION OF THE NUMBER ,I need to have 1 formula per number repeated.

Ex : The first formula would look for the 1st repeated number in the previous draw.

The second formula would look for the 2nd repeated number in the previous draw.... [ More ]