Hello, I have the following formula and it works super good:
=IFERROR(INDEX('Talent Management'!$B$2:$B$130,AGGREGATE(15,6,(ROW('Talent Management'!$B$2:$B$130)-ROW('Talent Management'!$B$2)+1)/('Talent Management'!$C$2:$C$130="EX-03"),ROWS(E$1:E1))),"")
The part that is underline I would like to stay and add also the data that matches "Well-Placed in Role" that would be found in column "U". Where would I insert that extra argument?
Thanks
=IFERROR(INDEX('Talent Management'!$B$2:$B$130,AGGREGATE(15,6,(ROW('Talent Management'!$B$2:$B$130)-ROW('Talent Management'!$B$2)+1)/('Talent Management'!$C$2:$C$130="EX-03"),ROWS(E$1:E1))),"")
The part that is underline I would like to stay and add also the data that matches "Well-Placed in Role" that would be found in column "U". Where would I insert that extra argument?
Thanks