Forum Discussion
Help needed for understanding with structured reference
Hi, i need a bit of help to understand something with structured reference in excels Table =DeptSales[Sales Amount],DeptSales[Commission Amount] A combination of two or more columns ,...
Structured Reference Union does not work as described in
https://support.microsoft.com/en-us/office/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e#:~:text=Structured%20references%20also%20appear%20when%20you%20create%20a,of%20typing%20their%20cell%20reference%20in%20the%20formula.
I have posted a question in:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_365hp/structured-reference-union-does-not-work/0f78fd96-1323-4a2a-aaaa-344586fa1d2a