Forum Discussion
Zacross
Dec 10, 2020Copper Contributor
[Excel Tables] Structured Refs - Column vs Rows
Hello everyone! I'm trying optimize a few excel files for work and started using more actively the Excel Table to ensure maximum automatization I was just wondering what's the difference between re...
Zacross
Dec 14, 2020Copper Contributor
Hello Sergei and thanks for your answer!
Unless I'm mistaken, I'm on Office 365
Based on your answer it looks like it behaves like your initially mentions : it silently do implicit intersection and returns only one element of this array for the current row
In practice it doesn't mess up my calculations, but I agree that the correct synthax would be [@Column A]
I'll take care about this in the future! But your answer was really clear - Thanks again!
SergeiBaklan
Dec 14, 2020Diamond Contributor
Zacross , you are welcome, good luck with Tables.