Count if the given numbers were drawn in lottery

**Bishonen** · 11-06-2012, 07:47 AM

Lottery.xlsm

Hi all,

I'm looking for a formula(quite sure it will be an array one), that would count if the given numbers were drawn in the lottery. The range where the formulas have to be entered is "L6:Q6". 3's = how many times at least 3 of the numbers above have been drawn in the same week.

Thanks

PS: I'm looking particulary for a single formula for each cell - I'm quite confident I can do it with help-formulas and with a vba code. But I'm interested in a single formula as i said.

**JFR2262** · 11-20-2012, 02:06 AM

where is it suppose to search the numbers?

**satputenandkumar0** · 11-20-2012, 02:16 AM

Dear Bishonen,

pls send the sample file.

Regards,
Nandkumar Satpute

------------------------------------------------------------------------------------------
CLICK the STAR icon on the left side below their user name to say thank you to those who had helped you. Thanks.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.

**crzu** · 11-20-2012, 02:18 AM

Could you put your data into an excel file and indicate the answer you like to have in your worksheet?

I think this would be better for us to visualize.