Excel FILTER Function (The New Excel Power Multi-Lookup)
Link to my first Dynamic Array video where I compared two complex tasks in legacy Excel to the new Excel.
🆕 You no longer need to use the F9 key to preview intermediate values of a formula in Excel for Microsoft 365. This is now built in with the value preview tooltip.
All you have to do is highlight the portion of the formula you want to see the results for or click on the given argument in the tooltip. The best part? You don't have to worry about pressing Esc or Ctrl+z. You don't risk committing any intermittent results permanently.
Check out this video where I show how this looks in practice.