lundi 23 mars 2020

Picking Random Cell, Ignoring empty

My coding skills aren't the best, but I know somewhat how to use excel/sheets.

I am trying to get a cell to select a random cell in a column, but ignore cells that are empty. So fare, I can get it to select a random cell, but how do I make it continue if the cell is empty?

More specifically, I had an idea for a game to play at an event based on the Magic the gathering game mode: Horde, and use Google Sheet as the "enemy" deck. The below link is just sample. Not the actual idea.

https://docs.google.com/spreadsheets/d/1XKMCguvpI_4PDtBYVXa4_FaH7O3WgckRWYbQ75_5F7E/edit?usp=sharing




Aucun commentaire:

Enregistrer un commentaire