Forum Discussion
Duplicate values using xlookup
I am getting the following response when trying to look for the Subcomp (Subcompetency) associated with the lowest Subcomp score. Xlookup keeps finding the first occurrence when there are multiples ...
Try this:
=SORT(CHOOSECOLS('Download sheet'!$A$4:$E$101,1,5,4,2),2,1)
Will try. Thanks! I am also trying a filter function embedded in a sort function