Forum Discussion
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...
Tengizi Forgive me for asking, but what is "the relationship function"? Mac user myself and have difficulty imagining what you refer to.
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.
Tengizi I see! Unfortunately, this is NOT supported by Excel for the Mac. It's a Windows only feature for version 2013 and later:
Actually that is supporting of data model - not for Mac.
Riny_van_Eekelen Okay and there is no other way we can do the same thing?
That is building of virtual relationships, aka XLOOKUP() or like.
