Hello there,

I have 186 rows of data and each cell in column A contains a non-consecutive value between 1 and 435,155.
For info, the total value of all cells in column A when added together is 11,816,883.

I would like to split these 186 rows across 8 people, all of which should end up with an amount of approximately 1,477,110 each (11,816,883 / 8 = 1,477,110).
I appreciate splitting the values into 8 groups means they won't all equal this number so as near as possible is fine.

The values in each row must remain as they are so once sorted into the groups, each person will have a different number of rows but their total value in column A will be (roughly) the same.

I have googled but found nothing matching my requirement unfortunately.
Is there a formula or way to do this please?

Thank you in advance for your help.

Regards,
Steve