Hi everyone.
I've just joined and I'm needing your help. I've just created an excel spreadsheet to calculate the share of lottery winnings for 20 people (syndicate). And have managed to readjust the share and total if someone leaves. But how do I add someone without giving them a full share of money already accumulated.
Hope this makes sense.

Jim