(Hopefully I can explain this accurately)
I would like to generate a column that summs the previous columns so that the last column results are as close together as possible. For example:
| Column A | Column B | Column C | Column D |
|---|---|---|---|
| 219.4 | 22.9 | 99.7 | 341.6 (Col1,Row1 + Col2,Row2 + Col3,Row1) |
| 218.5 | 22.5 | 99.9 | 341.1 (Col1,Row2 + Col2,Row1 + Col3,Row2) |
Essentially, I would like the numbers of the last column to be as close to each other as possible. All row items in each column can only be used once. There could be as many as 24 rows in the table at any time. Additional columns could also apply if necessary.
Any help would be greatly appreciated.
I just can’t figure this one out – I’ve played with calculations, but I just don’t have the skill for this…
Chris Wilson is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.