•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do i control the randomization of the values? (For mapmaking)
So i want to create a map in Excel, like an actual fantasy map. The values in the cell are the elevation. Then based on the elevation values, the color changes with conditional formatting.
I know I could manually input the values yes but I want to automatically generate them while still keeping a semblance of landmasses.
Right now I'm using the RAND() to randomize the values but as you can see the values are all over the place (see image below). How do I control the values randomization so that <0.1 (water) will group together and >0.1 (land) will not be isolated?
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#rows.com
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#natural language processing for spreadsheets
#generative AI for data analysis
#mapmaking
#Excel
#randomization
#elevation
#conditional formatting
#RAND()
#landmasses
#automatically generate
#values randomization
#values
#water
#land