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

 

[teylyn]

Add them how? Like a list in the spreadsheet? When you say "extract all the names from one particular section" do you mean to say "from a sector"?

Your question is not clear. Please add some more detail. Sample data, a screenshot, and a mock up of the desired result.

 

[Glacombe]

So sorry for not being clear,
I would like to include all the names from one sector out of the 14 and insert them in another worksheet as a list. My master list has over 50 columns and would like to add about 6 columns in a different sheet from the same master list and add the names matching one particular sector. This is an example of where the names would be added.

Name	A/AI/P/R	Level​	Rating	March 31/2020 Salary	% of Max	Salary Increase​	April 1/2020 Salary​

Thanks

 

[teylyn]

So, what is the connection with the table you just posted? It's neither 50 columns nor 6 and it doesn't help illustrate anything. What is the sector? Where is the source data? Which rows of the source data example would you want to include in the result?

We need the structure of the source with a few rows of data, AND the structure of the result with a few rows of data mocked up. Otherwise, how do you expect us to come up with a formula or other solution if you don't show where the data is and where the condition is that you base your selection on?

 

[Glacombe]

Sorry again the above is the results of the columns on my worksheet. I have 126 names total in my master worksheet and 14 sectors. For example one of the sector is called AEB. From that master, i want to have all the employees that matches that sector (AEB) inserted to a different worksheet. Also on my master worksheet the above columns identified are included.
Thanks

 

[teylyn]

I'm really failing to get this across.

If you expect us to provide a solution, we need to know the structure of your file. You have not posted what your source looks like. What column has the sector data?

There are a few different ways to approach this, but without knowing a bit more about your setup, it's hard to get into details.

Try Advanced Filter and send the data to a new sheet. How to do that? Post info about your data structure and we can work it out.

Or, create a pivot table and filter by the desired sector. How to do that? Well, post info about your data structure and we can tell you how.

Or, if you want a formula, post information about your data structure. A screenshot, a set of sample data.

 

[Glacombe]

Sorry, the data is confidential therefore, cannot post much, my document has 156 names (rows) and 14 sectors, it also contains over 50 columns, I would like to create a different sheet for each of the Sector and on each Sector sheet would like to get the names from the 156 in my master sheet that works in that particular sector. For example, there are 21 people working in HR, in the HR sheet, would like to insert from the master sheet, all the names from HR.

Thanks and again so sorry to be confusing

 

[teylyn]

I don't care about your original file. Create a sample file that has the same structure and change the names to dummy names. Use the seven dwarves or something. I don't need 156 names. Ten will do fine, if they belong to different sectors.

How will Excel know which sector a person belongs to? I need to know what that looks like in your spreadsheet. I don't need you to describe the spreadsheet with generic words like "21 people working in HR". That does NOT tell me in which column you have the name or in which column you have the sector, or if the name and the sector may even be in the same cell. I need to see what you see to be able to suggest a formula.

It's like giving you directions for a town I've never been to without being able to see the map of the town.

 

[Glacombe]

Ok will make a dummy sheet on Friday
Thanks and I do apologize for all the confusion

 

[Glacombe]

Good morning
Here is an example of the data needed to extract from my master file

Audit and Evaluation​
2019-2020​
Name	A/AI/P/R	Level​	Rating	March 31/2020 Salary	% of Max	Salary Increase​	April 1/2020 Salary​
	#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	#N/A	#N/A	#N/A	#N/A

What I would like is insert the names above that matches the ones that work in Audit and Evaluation

Here is an example of my master sheet

Branch

Name

A/P/S/I

Class

PRI

M/F

Date app't to level

March 31/19 salary

Jrate

Variance

% of max

Rating

% eligible in-range

Salary increase

Final salary April 1/19

% at-risk

At-risk amount

% bonus

Bonus amount

Total lump sum amount

Max at-risk % + Bonus

Max allowable amount

Comments

SUB LEVEL

SALARY SUB

A/P LEVEL

SALARY A/P

A/P2 LEVEL

SALARY A/P2

A/P3 LEVEL

SALARY A/P3

PRO-RATED SUB LUMP SUM

PRO-RATED A/P LUMP SUM

PRO-RATED A/P2 LUMP SUM

PRO-RATED A/P3 LUMP SUM

START SUB

END SUB

MONTHS AT SUB

START SUB2

END SUB2

MONTHS AT SUB2

START A/P

END A/P

MONTHS AT A/P

START A/P2

END A/P2

MONTHS AT A/P2

START A/P3

END A/P3

MONTHS AT A/P3

TOTAL MONTHS

TOTAL PRO-RATED SALARY

FRE OR ENG

2019-2020 RATING

2018-2019 RATING

2019-2020 TM PLACEMENT

2018-2019 TM PLACEMENT

FIRST NAME

LAST NAME

IBSDB

Bonnie

SCI

Amy

PPB

George

AEB

Michael

PPB

Fred

Ops

Tom

Ops

Carol

AEB

Paul

PPB

Monica

PresO

Price

PPB

Chantal

AEB

Monique

IAB

Pierre

Ops

Denis