=(INDEX(data,SMALL(IF((data,[POSITION]="Manager")(Data[Bonus]="yes")(data[relocation]=A1)OR*(data[relocation]=B1,ROW(data[relocation])),ROW(1:1))-1,COLUMN(Data[NAME]))
I've been trying to figure the above formula out for ages but still couldn't get it to work.
All I want is the formula to return me all the names of the managers with a bonus that are willing to relocate to either cities in A1 OR B1. I'm using Array so it can list as many managers as possible.
I tried to use OR in various nesting but couldn't figure out so I would appreciate any help, thank you
Aucun commentaire:
Enregistrer un commentaire