# total spread over 32 cells in rank

#### AugustusHaynes

##### New Member
Sorry about the awful title but this is quite hard to explain.

So I have 32 cells, let's just call them products, I also have a number of 24.768. This needs to be spread about between all 32 products in a rank, so the first product would get the highest % of 24.768. The tricky part (for me at least) is that the range is 24.768 through to -24.768. So if you added all 32 product values it would equal zero. Does this make any sense at all?

Ideally I need

Column A = Product name
Column B = Rank (1 to 32)
Column C = Value (best products will be in the positive range, worst in the negative range)

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
No idea what you're talking about whatsoever!

But... could you maybe work out proportions of 24.768 using the formula for triangle numbers?
So imagine you had 8 products. The first 4 would need the positive values. You would need to split the 24 into 1 + 2 +3 + 4 = 10 pieces (4th triangle number). Rank 1 would get the highest, 4/10 or 40% of 24. Product with rank 4 would get 1/10 of 24.

Replies
9
Views
448
Replies
2
Views
512
Replies
5
Views
382
Replies
15
Views
937
Replies
11
Views
885

1,221,417
Messages
6,159,789
Members
451,589
Latest member
Harold14

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back