Spreadsheet: 85728d1285774149-extract-data-extract-names-out-of-columns
Sheet: Sheet1

 |  |  |  |  |  | In this column, I would like a formula that can extract or match names once from Column J inputs
 |  |  |  |  |  | Name Task Owners |  |  |  |  | I want to extract names from Column J to develop some metrics, such as how many tasks assigned to a person
 |  |  |  |  |  |  |  |  | Most tasks will be single person, but some may have 2 or more team members assigned to task
 |  |  |  |  |  |  |  |  |  | Names appear multiple times
 |  |  |  |  |  |  |  |  | Task  Owner(s)
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | KANG
 |  |  |  |  |  |  |  |  | HOLT
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | KANG
 |  |  |  |  |  |  |  |  | WASSON
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | KANG
 |  |  |  |  |  |  |  |  | WASSON
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | KANG
 |  |  |  |  |  |  |  |  | MARCHAND
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | THOMAS
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | KANG
 |  |  |  |  |  |  |  |  | CORLISS
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | WITTLER
 |  |  |  |  |  |  |  |  | WASSON
 |  |  |  |  |  |  |  |  | WITTLER
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | LUDWICK
 |  |  |  |  |  |  |  |  | ROTT
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | WASSON
 |  |  |  |  |  |  |  |  | KANG
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | WASSON
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | BOCOOK
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | LADD
 |  |  |  |  |  |  |  |  | WASSON
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | KANG
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | KANG
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | ALEJ
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | wasson
 |  |  |  |  |  |  |  |  | WASSON
 |  |  |  |  |  |  |  |  | WASSON
 |  |  |  |  |  |  |  |  | WASSON
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | Anil
 |  |  |  |  |  |  |  |  | BOCOOK
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | ALEJ
 |  |  |  |  |  |  |  |  | ALEJ
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SOMA / BOOCOOK
 |  |  |  |  |  |  |  |  | ARUN / CURTISS
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | ARUN / SHERMAN
 |  |  |  |  |  |  |  |  | WASSON / LEE
 |  |  |  |  |  |  |  |  | SHERMAN / thomas
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | ARUN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | Kang
 |  |  |  |  |  |  |  |  | Alej
 |  |  |  |  |  |  |  |  | Rhodes
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | SHERMAN
 |  |  |  |  |  |  |  |  | Arun
 |  |  |  |  |  |  |  |  | [NAME]/Arun
 |  |  |  |  |  |  |  |  | [NAME]/Arun