mardi 1 août 2017

Excel Index Small If with OR statement

=(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