Randomizing a Data Column in order to change calculated values in another column.

Copper Contributor

I am trying to figure out a way to sort the numbers in column F, simply, ( ie: on click on a button) so that while viewing the spreadsheet on a large screen with a client we can change the data to demonstrate how Balances are impacted, not only, by the actual returns but also the order of the actual returns.  At that point, only the Balance Column numbers would be impacted.  

 

I am unsure of how that could be accomplished.  Any help is gratefully appreciated!

 

 

0 Replies