I need to be able to convert:
to:
where
Elist[NAME USED] = 'EMPLOYEE LIST'!L2:L382
Elist[[FH1]:[FH10]] = 'EMPLOYEE LIST'!BI2:BR382
Excel Formula:
=IFERROR(INDEX(Elist[NAME USED],AGGREGATE(15,6,(ROW(Elist[NAME USED])-ROW('EMPLOYEE LIST'!$L$2)+1)/((Elist[[FH1]:[FH10]]=$I$1)),ROWS($S$4:S4))),"")
to:
Excel Formula:
=IFERROR(INDEX('EMPLOYEE LIST'!L2:L382,AGGREGATE(15,6,(ROW('EMPLOYEE LIST'!L2:L382)-ROW('EMPLOYEE LIST'!$L$2)+1)/(('EMPLOYEE LIST'!BI2:BR382=$I$1)),ROWS($S$4:S4))),"")
where
Elist[NAME USED] = 'EMPLOYEE LIST'!L2:L382
Elist[[FH1]:[FH10]] = 'EMPLOYEE LIST'!BI2:BR382