Forum Discussion
Elva_Tanguerre
Oct 11, 2023Copper Contributor
Return primary value based on hierarchy
I have a list of names with groups they can belong to (one column per group). Some individuals belong to many groups but in the end, I need find their primary group, based on a hierarchy. For instanc...
mtarler
Oct 11, 2023Silver Contributor
In Excel 365 you can use:
=XLOOKUP("*",C2:G2,C$1:G$1,"",2,1)
=XLOOKUP("*",C2:G2,C$1:G$1,"",2,1)