Hello,

I'm relatively new to excel, so any help would be greatly appreciated. I have a row of numbers with a total:

A1 = 100
A2 = 100
A3 = 100
A4 = 100

A5 Total = 400

What I would like to do is to be able to delete a cell or cells (let's say A1) and have that difference spread evenly to the other cells, all the while keeping the same total. So the new numbers would be:

A1 = 0
A2 = 133.33
A3 = 133.33
A4 = 133.33

A5 Total = 400

Thanks!