Forum Discussion

Thorkild1991

Copper Contributor

Mar 19, 2020

Solved

List of data subjects

Hi, I have data set that looks a bit like this Project number Project Team member Role Hours Worked 1 Park Jack Engineer 5 1 Park Robin Engineer 7 1 Park Steph Manage...

Example.xlsx14 KB

excel

Savia
Mar 19, 2020
Thorkild1991 This is possible with Office 365's FILTER and UNIQUE functions - see attached.
Example (1).xlsx12 KB

Savia

Iron Contributor

Mar 19, 2020

Thorkild1991 This is possible with Office 365's FILTER and UNIQUE functions - see attached.

Example (1).xlsx12 KB

Thorkild1991

Copper Contributor

Mar 20, 2020

Thanks, this was just what I was looking for!