Forum Discussion

Thorkild1991's avatar
Thorkild1991
Copper Contributor
Mar 19, 2020
Solved

List of data subjects

Hi,

 

I have data set that looks a bit like this

Project numberProject Team memberRoleHours Worked
1ParkJackEngineer5
1ParkRobinEngineer7
1ParkStephManager4
1ParkLisaEngineer8
1ParkGregManager5
1ParkRalphController3
2City CenterGregManager4
2City CenterJennyEngineer2
2City CenterElisabethEngineer6
2City CenterRogerController2
2City CenterJackEngineer6
3BridgeJimEngineer9
3BridgeLisaManager4
3BridgeMichaelController3
3BridgeRobinEngineer5

 

In reality, the data set contains thousands of rows and hundres of project and team members. I want to sort them by project, in order to find out who worked on which project and for how long.

 

One of the easiest way of doing this is ofcourse to insert a pivot table, and have Project and Team members in Row and Hours Worked in Value. However, I want to make it a bit more automatic. 

 

Is there a formula that can list every team member based on either project number or project name?One where you can insert for instance the project number, and the names of everyone involved would automtically show up beneath the formula? Basicly, like a pivot, but formula based instead.

 

I know it may be a bit farfetched, but it would be of great help. I added an example data file. Contact me if you need more information. 

 

Thanks in advance!
Thor

4 Replies

Resources