I have a list of employees with multiple assigned codes. So each employee can have more than one code.
Employee Codes
Employee # 0006 MLUB2621
Employee # 0001 VMVW5126
Employee # 0005 TZSZ3296
Employee # 0004 WQHS5411
Employee # 0005 JILX3602
Employee # 0007 FMLN2422
Employee # 0005 UINI2337
Employee # 0004 VBFR3214
Employee # 0002 OATX4733
Employee # 0008 CVUU5403
Employee # 0009 JMPC2631
Employee # 0006 YPAI4427
Employee # 0002 AIMZ6609
Employee # 0006 SPFW1376
Employee # 0008 SQEN9141
Employee # 0003 JQNN7899
Employee # 0003 QFSO8664
Employee # 0007 EXTN4805
Employee # 0006 FCAA8980
Employee # 0007 UBDI9369
I need list out the unique employees, in a separate part of the spreadsheet, using a formula.
Next to that I need to list all of employees codes in one cell, again using a formula.
Unique Employees All Codes
Employee # 0001 VMVW5126
Employee # 0002 OATX4733, AIMZ6609
Employee # 0003 JQNN7899, QFSO8664
Employee # 0004 WQHS5411, VBFR3214
Employee # 0005 TZSZ3296, JILX3602, UINI2337
Employee # 0006 MLUB2621, YPAI4427, SPFW1376, FCAA8980
Employee # 0007 FMLN2422, EXTN4805, UBDI9369
Employee # 0008 CVUU5403, SQEN9141
Employee # 0009 JMPC2631
Employee Codes
Employee # 0006 MLUB2621
Employee # 0001 VMVW5126
Employee # 0005 TZSZ3296
Employee # 0004 WQHS5411
Employee # 0005 JILX3602
Employee # 0007 FMLN2422
Employee # 0005 UINI2337
Employee # 0004 VBFR3214
Employee # 0002 OATX4733
Employee # 0008 CVUU5403
Employee # 0009 JMPC2631
Employee # 0006 YPAI4427
Employee # 0002 AIMZ6609
Employee # 0006 SPFW1376
Employee # 0008 SQEN9141
Employee # 0003 JQNN7899
Employee # 0003 QFSO8664
Employee # 0007 EXTN4805
Employee # 0006 FCAA8980
Employee # 0007 UBDI9369
I need list out the unique employees, in a separate part of the spreadsheet, using a formula.
Next to that I need to list all of employees codes in one cell, again using a formula.
Unique Employees All Codes
Employee # 0001 VMVW5126
Employee # 0002 OATX4733, AIMZ6609
Employee # 0003 JQNN7899, QFSO8664
Employee # 0004 WQHS5411, VBFR3214
Employee # 0005 TZSZ3296, JILX3602, UINI2337
Employee # 0006 MLUB2621, YPAI4427, SPFW1376, FCAA8980
Employee # 0007 FMLN2422, EXTN4805, UBDI9369
Employee # 0008 CVUU5403, SQEN9141
Employee # 0009 JMPC2631