[SOLVED] Split an amount based on shares and number of people Hi,

Attached file got two sheets. one with amount and second with the amount split based on shares.

If you enter a figure in the shares column, it is then split into that many rows but I want this amount shown per person on the next row only and same with 50% share. so the split value shown...
https://www.excelforum.com/sho....wthread.php?t=142311