Spreadsheet: 767651d1644573003-trying-to-find-a-quick-way-to-fill-in-the-cells-using-excel-formulas-in-the-attachment-excel-help
Sheet: Sheet1

 | 2) Your task is to find a quick way and fill in the highlighted cells by using Excel formulas.
 | name | Company name | Hours - Week 1 |  | name | Company name | Hours - Week 2 |  | name | Company name | Hours - Week 1 | Hours - Week 2
 | [NAME] | Company 1 | 26.63 |  | [NAME] | Company 3 | 0.2 |  | [NAME]
 | [NAME] | Company 2 | 20.01 |  | [NAME] | Company 3 | 16.83 |  | [NAME]
 | [NAME] | Company 3 | 48.15 |  | [NAME] | Company 3 | 27.72 |  | [NAME]
 | Raina Devlin | Company 2 | 56.61 |  | Rufina Ortez | Company 1 | 0.12 |  | [NAME]
 | [NAME] | Company 2 | 39.51 |  | [NAME] | Company 3 | 38.56 |  | [NAME]
 | [NAME] | Company 2 | 30 |  | [NAME] | Company 2 | 8.88 |  | [NAME]
 | [NAME] | Company 2 | 10.45 |  | [NAME] | Company 2 | 29.66 |  | [NAME]
 | [NAME] | Company 3 | 23.73 |  | [NAME] | Company 3 | 41.29 |  | Danyell Hagen
 | [NAME] | Company 2 | 37.25 |  | Many [NAME] | Company 2 | 46.86 |  | [NAME]
 | Many [NAME] | Company 2 | 6.19 |  | [NAME] | Company 1 | 55.87 |  | Demetrius Pepin
 | [NAME] | Company 2 | 16.17 |  | [NAME] | Company 2 | 50.76 |  | Donnell Pulley
 | Demetrius Pepin | Company 2 | 38.27 |  | Eleanore Mangrum | Company 3 | 35.15 |  | Dorcas Rix
 | Eleanore Mangrum | Company 3 | 30.16 |  | [NAME] | Company 2 | 20.15 |  | Dulcie Burgamy
 | [NAME] | Company 1 | 58.09 |  | Nieves Behling | Company 1 | 12.73 |  | Eleanore Mangrum
 | Danyell Hagen | Company 1 | 18.31 |  | [NAME] | Company 3 | 12.73 |  | [NAME]
 | [NAME] | Company 1 | 64.63 |  | Dulcie Burgamy | Company 2 | 17.88 |  | [NAME]
 | Rufina Ortez | Company 1 | 50.09 |  | Donnell Pulley | Company 2 | 0.11 |  | [NAME]
 | [NAME] | Company 2 | 42.69 |  | [NAME] | Company 1 | 36.5 |  | [NAME]
 | Donnell Pulley | Company 2 | 14.98 |  | [NAME] | Company 2 | 24.05 |  | [NAME]
 | [NAME] | Company 2 | 35.82 |  | Miss Coppage | Company 1 | 11.28 |  | Hyon Almonte
 | [NAME] | Company 2 | 0 |  | [NAME] | Company 1 | 20.08 |  | [NAME]
 | [NAME] | Company 3 | 14.83 |  | Demetrius Pepin | Company 2 | 31.44 |  | [NAME]
 | Hyon Almonte | Company 1 | 0.08 |  | [NAME] | Company 1 | 41.93 |  | [NAME]
 | [NAME] | Company 1 | 15.22 |  | [NAME] | Company 3 | 46.97 |  | [NAME]
 | [NAME] | Company 2 | 46.69 |  | [NAME] | Company 1 | 49.78 |  | [NAME]
 | [NAME] | Company 2 | 39.03 |  | Danyell Hagen | Company 1 | 45.68 |  | [NAME]
 | [NAME] | Company 2 | 22.92 |  | [NAME] | Company 2 | 19.5 |  | [NAME]
 | [NAME] | Company 3 | 38.05 |  | Hyon Almonte | Company 1 | 0.17 |  | [NAME]
 | [NAME] | Company 2 | 56.5 |  | [NAME] | Company 2 | 7.27 |  | [NAME]
 | [NAME] | Company 1 | 52.16 |  | [NAME] | Company 1 | 66.03 |  | [NAME]
 | [NAME] | Company 3 | 34.92 |  | [NAME] | Company 2 | 39.52 |  | [NAME]
 | [NAME] | Company 1 | 25.46 |  | [NAME] | Company 2 | 21.49 |  | [NAME]
 | Nieves Behling | Company 1 | 44.31 |  | [NAME] | Company 3 | 22.1 |  | Many [NAME]
 | [NAME] | Company 3 | 18.55 |  | [NAME] | Company 3 | 19.89 |  | [NAME]
 | [NAME] | Company 3 | 22 |  | [NAME] | Company 2 | 51.01 |  | [NAME]
 | [NAME] | Company 3 | 14.87 |  | [NAME] | Company 3 | 0.08 |  | [NAME]
 | Miss Coppage | Company 1 | 15.1 |  | [NAME] | Company 1 | 3.22 |  | Miss Coppage
 | [NAME] | Company 3 | 5.66 |  | Raina Devlin | Company 2 | 28.89 |  | Nieves Behling
 | [NAME] | Company 2 | 52.17 |  | [NAME] | Company 2 | 3.76 |  | [NAME]
 | [NAME] | Company 2 | 9.03 |  | [NAME] | Company 2 | 45.6 |  | [NAME]
 | Dorcas Rix | Company 1 | 32.04 |  | [NAME] | Company 1 | 28.24 |  | Paulette [NAME]
 | Paulette [NAME] | Company 2 | 69.84 |  | [NAME] | Company 2 | 44.96 |  | [NAME]
 | [NAME] | Company 1 | 0.06 |  | [NAME] | Company 2 | 11.51 |  | Raina Devlin
 | [NAME] | Company 2 | 8.35 |  | Paulette [NAME] | Company 2 | 16.39 |  | [NAME]
 | Dulcie Burgamy | Company 2 | 31.4 |  | [NAME] | Company 2 | 13.05 |  | [NAME]
 | [NAME] | Company 2 | 19.77 |  | Dorcas Rix | Company 1 | 61.38 |  | [NAME]
 | [NAME] | Company 3 | 0.09 |  | [NAME] | Company 1 | 47.31 |  | Rufina Ortez
 | [NAME] | Company 1 | 14.9 |  | [NAME] | Company 2 | 26.47 |  | [NAME]
 | [NAME] | Company 1 | 49.98 |  | [NAME] | Company 2 | 16.07 |  | [NAME]
 | [NAME] | Company 3 | 0 |  | [NAME] | Company 3 | 14.17 |  | [NAME]