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