randbetween function - no duplicates in specific area?

You call it a "Bingo Card" but all the Bingo Cards I am familiar with restrict what numbers can be in each column. For example, the first column which is always(?) title "B" can only have the numbers 1 through 15... each succeeding column can only have the next set of 15 numbers until the "O" column is reached which can only have the numbers 60 through 75 in it. Are you saying your Bingo Cards do not follow this rule... that any of the 75 numbers can be in any column so long as no number duplicates?

Originally Posted by Rick Rothstein

You call it a "Bingo Card" but all the Bingo Cards I am familiar with restrict what numbers can be in each column. For example, the first column which is always(?) title "B" can only have the numbers 1 through 15... each succeeding column can only have the next set of 15 numbers until the "O" column is reached which can only have the numbers 60 through 75 in it. Are you saying your Bingo Cards do not follow this rule... that any of the 75 numbers can be in any column so long as no number duplicates?

my intention is to not have them follow the standard 1-15 16-30 31-45 etc etc rules of standard bingo. If that makes this way more difficult, I suppose I could live with the standard sequences.

I was just checking that you actually wanted what you appeared to be asking for. Okay, with that said, I cannot think of a way to do what you want with formulas. I do have a way to do it with a VBA macro, would you by any chance be open to such a solution? If not, maybe someone else more knowledgeable in formulas than I am will come along and provide you with a formula solution.

I'm open to it though my VBA knowledge is pretty much copy/pasting someone else's macro in and pressing run

Originally Posted by SineNomine

I'm open to it though my VBA knowledge is pretty much copy/pasting someone else's macro in and pressing run

Here is a macro along with a function that the macro calls in order to randomize the array for each Bingo Card outputted.

Please Login or Register  to view this content.

HOW TO INSTALL MACROs
------------------------------------
If you are new to macros, they are easy to install and use. To install it, simply press ALT+F11 to go into the VB editor and, once there, click Insert/Module on its menu bar, then copy/paste all of the above code (both the macro and function) into the code window that just opened up. That's it.... you are done. To use the macro, go back to the worksheet with your data on it and press ALT+F8, select the macro name (Bingo) from the list that appears and click the Run button. The macro will execute and perform the action(s) you asked for. If you will need to do this again in this same workbook, and if you are using XL2007 or above, make sure you save your file as an "Excel Macro-Enabled Workbook (*.xlsm) and answer the "do you want to enable macros" question as "yes" or "OK" (depending on the button label for your version of Excel) the next time you open your workbook.

Thank you this worked well!

Just so we and future readers of this thread know what worked well, who was your comment directed at (my guess is Bo_Ry's, but you should make it clear)?

oh, in the end as I'm actually using words instead of numbers the VBA worked the best for me as I was able to just find and replace the numbers with the words I was using, though all solutions seemed like they'd work if I were purely using numbers