▲ 1 r/excel
Efficiently filling formulas in an upper triangular table
I have a table that looks like the one below where the letters are category headers, and the numbers are calculated by a formula. Fill works to propagate the formula throughout the table, but it's important for readability that only the upper triangle is filled, which is inefficient the way I do it now: Fill across row 2, select rightmost N-1 cells, fill down to row 3, select rightmost N-2 cells, fill down to row 4, etc.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| A | 1 | 2 | 2 | 3 | 3 |
| B | 1 | 2 | 3 | 3 | |
| C | 1 | 3 | 3 | ||
| D | 1 | 0.5 | |||
| E | 1 |
Is there a more efficient way to do this? Some of the tables are pretty big, and it's a lot of clicking.
u/Ancient-Swordfish292 — 1 day ago