Forum Discussion
Tengizi
Dec 12, 2020Copper Contributor
Help to find "Relationship" function on MAC version 16.43
Hello, I have a 16.43 version of Excel for Mac and I can't find the "Relationship" function, it is nowhere. Can you please tell me if there is some way I can activate/add this function or any other a...
Riny_van_Eekelen
Dec 12, 2020Platinum Contributor
Tengizi Forgive me for asking, but what is "the relationship function"? Mac user myself and have difficulty imagining what you refer to.
Tengizi
Dec 12, 2020Copper Contributor
Riny_van_Eekelen Here you can find what it is about. https://support.microsoft.com/en-us/office/create-a-relationship-between-tables-in-excel-fe1b6be7-1d85-4add-a629-8a3848820be3#:~:text=Give%20each%20table%20a%20meaningful,one%20column%20contains%20unique%20values.
- Riny_van_EekelenDec 12, 2020Platinum Contributor
Tengizi I see! Unfortunately, this is NOT supported by Excel for the Mac. It's a Windows only feature for version 2013 and later:
- SergeiBaklanDec 12, 2020Diamond Contributor
Actually that is supporting of data model - not for Mac.
- TengiziDec 12, 2020Copper Contributor
Riny_van_Eekelen Okay and there is no other way we can do the same thing?
- SergeiBaklanDec 12, 2020Diamond Contributor
That is building of virtual relationships, aka XLOOKUP() or like.