Spreadsheet: 686630d1594728566-problem-with-formula-to-find-count-of-unique-values-herber
Sheet: RAW DATA

ID | Processed Date | Column14 | Process | Activity | Associate | Column15 | Document Number | Request Type | Lines | Received Date | Received Time | Output | Check 1 | Check 2 | Check 3 | Check 4 | Check 5 | Check 6 | Status | Remarks | Column16 | Duration | Processing Start Time | Processing End Time | Column17 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13
68 | 14/07/2020 |  | EU - DEU ORDER ENTRY | Production | GUJADHUR.H | 0.62474537037037 | 1111111G | M | 1 |  |  |  |  | Delivery Date checked |  |  | Order Data checked |  | Complete |  | 0.626469907407407 | 2 | 14:59:38 | 15:02:07 | Item | False |  |  |  |  | 2020-07-14 04:02:09 | 2020-07-14 04:02:09 | 30 | 30 | teams/MUSQMSDOCS/Lists/ProdTrackerData/68_.000;#68 | teams/MUSQMSDOCS/Lists/ProdTrackerData | 0 | https://avantorsciences.sharepoint.com/teams/MUSQMSDOCS/Lists/ProdTrackerData/68_.000
69 | 14/07/2020 |  | EU - DEU ORDER ENTRY | Production | DASSAGNE.V | 0.624664351851852 | 1111111D | M | 1 |  |  |  |  |  |  |  |  |  | Complete |  | 0.626678240740741 | 2 | 14:59:31 | 15:02:25 | Item | False |  |  |  |  | 2020-07-14 04:02:26 | 2020-07-14 04:02:26 | 30 | 30 | teams/MUSQMSDOCS/Lists/ProdTrackerData/69_.000;#69 | teams/MUSQMSDOCS/Lists/ProdTrackerData | 0 | https://avantorsciences.sharepoint.com/teams/MUSQMSDOCS/Lists/ProdTrackerData/69_.000
70 | 14/07/2020 |  | EU - DEU ORDER ENTRY | Production | [NAME] | 0.624583333333333 | 1111111H | M | 1 |  |  |  |  |  |  |  |  |  | Complete |  | 0.626909722222222 | 3 | 14:59:24 | 15:02:45 | Item | False |  |  |  |  | 2020-07-14 04:02:47 | 2020-07-14 04:02:47 | 30 | 30 | teams/MUSQMSDOCS/Lists/ProdTrackerData/70_.000;#70 | teams/MUSQMSDOCS/Lists/ProdTrackerData | 0 | https://avantorsciences.sharepoint.com/teams/MUSQMSDOCS/Lists/ProdTrackerData/70_.000
71 | 14/07/2020 |  | EU - DEU ORDER ENTRY | Production | [NAME] | 0.62693287037037 | 22222222H | M | 2 |  |  |  |  |  |  |  |  |  | Complete |  | 0.628958333333333 | 2 | 15:02:47 | 15:05:42 | Item | False |  |  |  |  | 2020-07-14 04:05:44 | 2020-07-14 04:05:44 | 30 | 30 | teams/MUSQMSDOCS/Lists/ProdTrackerData/71_.000;#71 | teams/MUSQMSDOCS/Lists/ProdTrackerData | 0 | https://avantorsciences.sharepoint.com/teams/MUSQMSDOCS/Lists/ProdTrackerData/71_.000
72 | 14/07/2020 |  | EU - DEU ORDER ENTRY | Production | DASSAGNE.V | 0.626701388888889 | 222D | M | 2 |  |  |  |  |  |  |  |  |  | Complete |  | 0.629305555555556 | 3 | 15:02:27 | 15:06:12 | Item | False |  |  |  |  | 44026.17099537037 | 44026.17099537037 | 30 | 30 | teams/MUSQMSDOCS/Lists/ProdTrackerData/72_.000;#72 | teams/MUSQMSDOCS/Lists/ProdTrackerData | 0 | https://avantorsciences.sharepoint.com/teams/MUSQMSDOCS/Lists/ProdTrackerData/72_.000
73 | 14/07/2020 |  | EU - DEU ORDER ENTRY | Assignment | GUJADHUR.H | 0.626493055555556 |  |  |  |  |  |  |  |  |  |  |  |  | Complete |  | 0.63244212962963 | 8 | 15:02:09 | 15:10:43 | Item | False |  |  |  |  | 44026.17413194444 | 44026.17413194444 | 30 | 30 | teams/MUSQMSDOCS/Lists/ProdTrackerData/73_.000;#73 | teams/MUSQMSDOCS/Lists/ProdTrackerData | 0 | [NAME]
74 | 14/07/2020 |  | EU - DEU ORDER ENTRY | Production | DASSAGNE.V | 0.629328703703704 | 3333D | M | 1 |  |  |  |  |  |  |  |  |  | Complete |  | 0.632581018518518 | 4 | 15:06:14 | 15:10:55 | Item | False |  |  |  |  | 44026.17425925926 | 44026.17425925926 | 30 | 30 | teams/MUSQMSDOCS/Lists/ProdTrackerData/74_.000;#74 | teams/MUSQMSDOCS/Lists/ProdTrackerData | 0 | https://avantorsciences.sharepoint.com/teams/MUSQMSDOCS/Lists/ProdTrackerData/74_.000
75 | 14/07/2020 |  | EU - DEU ORDER ENTRY | Production | [NAME] | 0.628993055555556 | 33333333H | M | 2 |  |  |  |  |  |  |  |  |  | Complete |  | 0.632638888888889 | 5 | 15:05:45 | 15:11:00 | Item | False |  |  |  |  | 44026.17431712963 | 44026.17431712963 | 30 | 30 | teams/MUSQMSDOCS/Lists/ProdTrackerData/75_.000;#75 | teams/MUSQMSDOCS/Lists/ProdTrackerData | 0 | [NAME]
 |  |  |  |  |  |  |  | 2020-07-14 00:00:00
 |  |  |  |  |  |  |  | EU - DEU ORDER ENTRY