I've attached a worksheet which shows the inputs, and the desired result for a table I want to create.
There are two fixed values (e.g. 15% and 40%) which I want to assign to x number of rows, so that 80% of the rows are filled with the value of 15%, and the remaining rows are filled with the value of 40%.
Any advice? Thanks.
Bookmarks