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

Riny_van_Eekelen

Platinum Contributor

Mar 19, 2020

Thorkild1991 If you have the latest Excel, FILTER can to the trick. The attached workbook contains an example.

Example-rev.xlsx16 KB

Thorkild1991
Copper Contributor
Mar 20, 2020
Thanks!