mardi 18 avril 2017

From a starting ActiveCell, how to randomly generate surrounding cells and further randomly generate from a specific value

I am trying to get cells to visually represent a randomized set of numbers, that are able to expand outward based on a while loop (lets start small with just making this a 5x5 grid though and I can update as necessary).

EXAMPLE: if my center active cell is a number =randbetween(1,10) where the answers of 1-9 place more random numbers from 1-10 in the adjacent cells surrounding it. However, if the value is "10" I want the cells around this cell that haven't been filled in to have the formula next to them being =randbetween(11,20). I can't seem to figure out how to do this without having it overwrite everything and just being one set of numbers.

The answer from this can also be used for non-randomized usage (like if someone wanted to show how if there was a chair in one space then they know that either a table or a trashcan etc would be in the space next to it)

Thanks for taking a look at my question!

It should look like this when it is done: imgur.com/a/LnVPA




Aucun commentaire:

Enregistrer un commentaire