•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I split a value in one cell on a variable amount of cells
Say I have a main value of 2000. I want to split this into 50 cells, but be able to increase the amount of cells by increasing the column so in this example each cell should contain 40 if I increase to 100 each cell contains 20 and so on. Don’t know if this is possible, but would be helpful in my case.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#value
#cells
#split
#increase
#amount
#column
#main value
#contain
#cells contain
#example
#case
#variable
#calculation
#distribution
#possible
#50 cells
#100 cells