The Presky @ Symbol

[excelbytes]

I received a file from a client claiming that his formula was not working. He is using Office Professional Plus 2019. I am using Microsoft 365. His formula is:

=IFERROR(@INDEX('Monthly Meters Printable'!$C$68:$C$85,SMALL(IF(@'Monthly Meters Printable'!$D$68:$D$85='Monthly Meters Printable'!$G$1,@ROW('Monthly Meters Printable'!$C$68:$C$85)),@ROW('Monthly Meters Printable'!1:1))-67,1),"")

No results appear. When I remove the "@" symbols it works:

=IFERROR(INDEX('Monthly Meters Printable'!$C$68:$C$85,SMALL(IF('Monthly Meters Printable'!$D$68:$D$85='Monthly Meters Printable'!$G$1,ROW('Monthly Meters Printable'!$C$68:$C$85)),ROW('Monthly Meters Printable'!1:1))-67,1),"")

I am certain he didn't manually insert them. What causes those to appear and how do we stop it?

 

[Fluff]

They will only appear in your version of 365, not in 2019.
That said the formula should be confirmed with Ctrl Shift Enter, rather than just enter

 

[excelbytes]

They will only appear in your version of 365, not in 2019.
That said the formula should be confirmed with Ctrl Shift Enter, rather than just enter

OK, but why will they appear in my file and the formula only work in my file when I remove them? Does it have something to do with the fact that 365 doesn't require CSE to enter array formulas?

 

[MARK858]

Does it have something to do with the fact that 365 doesn't require CSE to enter array formulas?

Yes, see the link below, but if you do a search on "Implicit intersection operator breaks my formula" you'll find plenty of instances when it does cause issues (and for various reasons)

Implicit intersection operator: @ - Microsoft Support

Learn about the implicit intersection operator (@), which returns a single value using logic known as implicit intersection. The implicit intersection operator (@) may return a value, single cell range, or an error. The implicit intersection operator (@) is in a class of functions called dynamic...

support.microsoft.com