Formula to insert names

[Glacombe]

Good afternoon, I have a worksheet that contains employees and their sectors, which we have 14 sectors, what would be the formula to extract all the names from one particular section and add them to another sheet within the workbook?

Thanks

 

[Glacombe]

Sorry Fluff my bad

 

[Glacombe]

Hey Fluff, it works super and thank you so much you're awesome

You never said it was a different column.
try

=IFERROR(INDEX('List of Ex1-5'!$B$2:$B$126,AGGREGATE(15,6,(ROW('List of Ex1-5'!$B$2:$B$126)-ROW('List of Ex1-5'!$B$2)+1)/('List of Ex1-5'!$A$2:$A$126="AEB")/('List of Ex1-5'!$D$2:$D$126="AS-07"),ROWS(A$1:A3))),"")

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Glacombe]

You're welcome & thanks for the feedback.

How do you mark it solved again

 

[Fluff]

You don't.