Do you mean that you want a method of generating the number in B, or
that you want to be able to split B up to show which numbers from
column A are added together?

Are the numbers in A in any particular order?

Pete