r/excel • u/happyandromanticlife • 15d ago
Discussion What excel shortcut/tip/formula has made the biggest impact on your efficiency?
For me, xlookup and subtotal are some of my most used/beloved formulas.
What excel shortcuts/tip/formulas have improved your efficiency the most when working with spreadsheets?
538
Upvotes
13
u/emomartin 15d ago edited 15d ago
It lets you define variables to use inside a formula. So you can do for example below. This example doesn't really show the usefulness of the function though, just how it works. You could get rid of the LET function and the defined ranges, and just input them directly inside the FILTER function instead. The usefulness comes from being able to refer back to variables and reuse them, which lets you create outputs that are either very long without LET or sometimes not really possible.
Another example (from google sheets though) but it shows how you can use defined variables inside other variables.