I would like to build a spreadsheet that simulates a Keno Ticket. 10 columns of 8 rows for a total of 80 cells. Each cell in each row individually numbered

1-10

11-20

21-30

31-40

41-50

51-60

61-70

71-80.

Then I would like a row of 20 cells that I could copy and paste the keno results into.

Then I would like each of the 80 cells in the first spreadsheet to look at the 20 random numbers and IF there is a match to place an “X” in the cell.

I have no idea how to write this function. Any help would be appreciated.

Bob

By: Bob