Forum Discussion
What is the formula for counting each number from 1to25 that hits from each drawing?
I want to calculate the daily numbers for cash25 lotto. The numbers are drawn on Monday, Tuesday, Thursday, and Friday of each week. Six number from 1 to 25 are drawn each time. I have 157 rows and 7...
=GROUPBY(TOCOL(B1:G157),TOCOL(B1:G157),LAMBDA(x,COUNT(x)),,0)This formula returns the intended result in my Excel online sample sheet.