Dividing dollar amounts unevenly into varying numbers of cells/columns

I have dollar amounts that I need to distribute among varying numbers of columns and not have have the total distributed be over or under the original amount by any number of cents. When I simply divide the dollar amount by the number of columns, the total of those columns can sometimes be more or less than the original dollar amount by a few cents.

I know I could simply always add or take away the pennies from one column, but I would prefer the process to be random or formulated in such a way that the Column to which the extra pennies are added to or taken away from differs in order to be "fair to each column".

ie. 4 columns with 3 cents remainder to be distributed to 3 of the for columns, such as $20.07/4 = $5.01 (+ remainder) therefore 3 columns s/b $5.02 and 1 column $5.01

Hi, please see attached an example for 3 columns.

Thank you. It's given me an idea of how I can use it.