Ok, I've been using Excel for many years but I'm not considered an expert by any stretch ...

This problem has me stumped and maybe there is no simple solution...but I'm hoping there is

I have dollar amounts that I need to distribute amongst 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.
e.g.
Dollar    # of       A        B         C         All Columns
Amount    Columns                                 Total
--------------------------------------------------------------------
$25.05     2        $12.53    $12.53              $25.06
$11.47     3        $ 3.82    $ 3.82    $ 3.82    $11.46
$25.05 divided into 2 columns gives $12.53 in Column A and $12.53 in Column B. Total of Columns A and B is $25.06. Over by a penny.

$11.47 divided into 3 columns gives $3.82 in Columns A through C. Total of Columns A through C is $41.46. Under by a penny.

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".

Man, I hope I explained that properly.

Thanks for ANY help with this.