2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/Ancient-Swordfish292
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com