•2 min read•from 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.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#generative AI for data analysis
#Excel compatibility
#big data performance
#Excel alternatives
#upper triangular table
#formulas
#efficiently
#formula propagation
#filling
#row filling
#Excel
#readability
#table structure