|
|
|
|
|
|
by otikik
1421 days ago
|
|
|
> the entire paradigm revolves around knowing the shape of your data in advance. This is true, but you can improve things significantly by using named ranges. Using `$PAYMENTS` instead of `Sheet2!$B2:$B$21` for your column data and `$TAX_RATE` instead of `$Sheet4!$A$1` clarifies things quite a lot. You still will need to know how your data is structured (e.g. this is a column that goes down, this is a fixed variable) but it is way more readable. |
|
|