Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/08/@-Symbol-in-Formula.xlsx

In this video, I discuss the implicit intersection operator or @ symbol that sometimes appears in front of your formulas in Excel 365. The @ symbol is most likely to appear in front of formulas that you have written in older versions of Excel.

Implicit intersection is where a formula returns an array of values but only displays one. This is was the default behaviour of formulas in Excel prior to Excel 365. Excel 365 behaves differently in that it spills an array of results into surrounding cells.
------------------------