Total percentage equals 100% after deleting a column.

[Monica S G]

Hi Team,

What formula is used when any of the column is deleted from the sheet and that equal to 100%?

For example:

C1 C2 C3 C4 C5 C6 C7
15% 10% 15% 20% 30% 10% = 100% (Sum is 100%)

If C3 and C5 column us deleted, it should automatically consider 100% in the C7 column. Please provide the insights on the same.

 

[Monica S G]

attached image for your reference.

Can you please check on priority please?

 

[SanjayGMusafir]

when 15% is deleted, it should spread equally between other 5 columns and total should be 100% something that 15% will spread equally or unequally among them. Can you please suggest anything?

For this I already explained you about Circular Reference

 

[Michael M]

I believe you would need to use VBA for this, as @SanjayGMusafir has suggested, you are trying to solve a circular reference by formula