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

 

[Fluff]

You have a space at the beginning of the sheet name, that's what's causing the problem.
Either delete the space from the sheet name, or modify the formula to add the space

 

[Glacombe]

OMG thank you for noticing that space, maybe that is why I always had trouble with the rest of formulas in my sheet.

Thanks again it works now

 

[Fluff]

You're welcome & thanks for the feedback

 

[Glacombe]

Hello, remember your famous formula that I manage to love and it worked like a charm, what would it be if I wanted to match another word besides the one that is already in the formula?
Thanks

 

[Glacombe]

=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"),ROWS(A$1:A3))),"")

This is the formul, it matches "AEB" and want to also match "AS-07" is that doable?

 

[Fluff]

How about

=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'!$A$2:$A$126="AS-07")),ROWS(A$1:A3))),"")

 

[Glacombe]

Thanks Fluff, it keeps inserting the same name and in my spreadsheet I have 10 names that is with AEB and are AS-07

 

[Glacombe]

Here is the sample of master list

Branch	Name	A/P	Class
AEB	Lorraine		PG-06
AEB	Christine		AS-07
AEB	Laura Lee		AS-07
AEB	Carla		AS-07
PB	Julie		AS-07
AEB	Douglas	A	FI-04
AEB	Shirley	A	AS-07
SPB	Doug		PE-06
SPB	Lucille		PE-06
SPB	Anne		AS-07

 

[Fluff]

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))),"")

 

[Glacombe]

And here is the worksheet for the names to be inserted

CMB

DMO

ISB

PAB

AS-07

#N/A​

to insert name here

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​

#N/A​