Help to find "Relationship" function on MAC version 16.43

Copper Contributor

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?

6 Replies

@Tengizi Forgive me for asking, but what is "the relationship function"? Mac user myself and have difficulty imagining what you refer to.

@Tengizi I see! Unfortunately, this is NOT supported by Excel for the Mac. It's a Windows only feature for version 2013 and later:

Screenshot 2020-12-12 at 15.19.34.png

@Riny_van_Eekelen Okay and there is no other way we can do the same thing? 

@Riny_van_Eekelen 

Actually that is supporting of data model - not for Mac.

@Tengizi 

That is building of virtual relationships, aka XLOOKUP() or like.