How do I randomly sort a list of terms in Excel?

Randomly..well. Did you enter your terms randomly?

Well, how many columns do you have?

What you need to do is create a lookup table where each word is matched up with a number. These can be in 2 columns to make it simple.

So for example:

1 Heart
2 Kidney
3 Bladder

Then you need to make a cell somewhere which is =randbetween(1,43). Next to this cell write =lookup([insert cell reference for the cell with the randbetween function], [insert the whole lookup table range], [select the column of the words you want to appear])

You can then just write out the words on Excel in a column and every time you click enter to enter a new word, another word will appear randomly. The problem is that the same word may appear twice or more in which case you can just ignore it.

It’s a bit of work but it gets the job done. You can program something with macros if you had loads and loads of bingo cards to make but this way is probably quicker and simpler.

Let me know if you have any problems and I can probably make the sheet for you. Only problem is I am going to sleep in 10 mins so you’ll have to be fast if you needed this for tomorrow :D.

Building on Ame_Evil’s idea, I think I have an easier method.

- Create two columns
– Column A is Ame_Evil’s formula =randbetween(1,43).
– Column B is your list of words
– Sort by column A

The random values will constantly change, you won’t get the same result twice.
If you want to “fix” column A, giving it unchanging values:
– Copy Column A
– Right-click and choose ‘Paste Special…’
– Choose ‘Values’
– Click OK to paste static values on top of column A