I need a formula in Column H that only gets the value corresponding to the greatest date - provided value in B is equal to Value in C and appears together more than once. (as shown in the picture)
tried using some variation of the Max date function
| A | B | C | StartDateTime | EndDateTime | DurationinMin | Date | Formula Needed |
|---|---|---|---|---|---|---|---|
| 324 | 235062-22-001 | CLEANING | 4/4/2023 1:12 | 4/4/2023 1:36 | 23.09 | 4/4/2023 | |
| 324 | 235062-22-001 | CLEANING | 4/5/2023 0:11 | 4/5/2023 0:18 | 7.15 | 4/5/2023 | |
| 324 | 235062-22-001 | CLEANING | 4/5/2023 1:33 | 4/5/2023 1:57 | 23.03 | 4/5/2023 | |
| 324 | 235062-22-001 | CLEANING | 4/5/2023 17:35 | 4/5/2023 17:59 | 23.97 | 4/5/2023 | |
| 324 | 235062-22-001 | CLEANING | 4/5/2023 21:06 | 4/5/2023 21:59 | 53.26 | 4/5/2023 | |
| 324 | 235062-22-001 | CLEANING | 4/6/2023 0:12 | 4/6/2023 0:55 | 43.15 | 4/6/2023 | 43.15 |
| 324 | 235062-22-001 | WASHING | 4/12/2023 11:23 | 4/12/2023 12:49 | 85.56 | 4/12/2023 | 85.56 |
| 324 | 235062-22-001 | PEALING | 4/13/2023 5:03 | 4/13/2023 6:01 | 57.82 | 4/13/2023 | 57.82 |