divide each percentage associated with a non-null letter by the sum of all
the percentages of non-null letters.

--
Regards,
Tom Ogilvy

"Sophia" wrote in message
...
How do I redistribute the percentage of one or more values that are null?

For instance if E is null then the 10% associated with it ought to be
redistributed to A, B, C and D according to their %s.

A 50%
B 20%
C 10%
D 10%
E 10%
100%

I know that there is a smart formular for this.

Thank you all for your help
Diana