Hello - I am working on a bingo game for our upcoming convention. We would like to design our own bingo cards – adding high res graphics and images. Adobe InDesign will allow us to import an Excel database however the data needs to run horizontally.
The import file for Adobe I created (attached) has 25 cells running across the row. Columns A, F, K, P, U represent the numbers for the letter "B" in Bingo. Columns B, G, L, Q, V represent the numbers for the letter "I" in Bingo and so on. The first tab is randomly generated. The second tab is a locked down file to show my problem. I am getting repeated values (see the yellow highlighted cells in rows 4 & 5 on the second tab). This is not acceptable in Bingo and would take us too long to manually proofread and correct 800 cards.
I used the formulas:
For the letter B =RAND()*(16-0)+0
For the letter I =RAND()*(31-15)+15
For the letter N =RAND()*(46-30)+30
For the letter G =RAND()*(61-45)+45
For the letter O =RAND()*(76-60)+60
I would like to know how to manipulate the formula to not have numbers repeated in a given ROW. Does anyone know how to accomplish this?
Bookmarks