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 | , (comma) union operator | C2:C7, E2:E7 |
I can't use this thing, the , comma union operator doesn t work, but i can use the : (colon) as below and i really don't understand why.
=DeptSales[[Sales Person]:[Region]] | All of the cells in two or more adjacent columns | : (colon) range operator | A2:B7 |
Thanks for your help and sorry for mybad english 🙂
14 Replies
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
here a sample file and what i wanna do
- https://support.microsoft.com/en-us/office/using-structured-references-with-excel-tables-f5ed2452-2337-4f71-bed3-c8ae6d2b276e
