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