Ok... So I have seven columns... I want to find the duplicate rows (c column) and then find the rows that don't have a value of QC in column F, then return the number in column G of the duplicate rows that don't have a value of QC in column F but are duplicate values in column C.
ANY HELP IS APPRECIATED
A B C D D F G
<colgroup><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>
ANY HELP IS APPRECIATED
A B C D D F G
25-Nov-17 | 11:02:47 | 17-3290056 | EMS Response | 140 | MM | 137 |
25-Nov-17 | 11:02:47 | 17-3290056 | EMS Response | 140 | OC | 137 |
25-Nov-17 | 10:09:29 | 17-3290049 | EMS Response | 140 | QC | 182 |
25-Nov-17 | 10:09:29 | 17-3290049 | EMS Response | 140 | MM | 204 |
25-Nov-17 | 10:09:29 | 17-3290049 | EMS Response | 140 | OC | 204 |
25-Nov-17 | 06:22:56 | 17-3290029 | EMS Response | 140 | MM | 157 |
25-Nov-17 | 06:22:56 | 17-3290029 | EMS Response | 140 | OC | 157 |
25-Nov-17 | 06:22:56 | 17-3290029 | EMS Response | 140 | QC | 178 |
25-Nov-17 | 01:41:46 | 17-3290010 | EMS Response | 140 | QC | 153 |
25-Nov-17 | 01:41:46 | 17-3290010 | EMS Response | 140 | MM | 164 |
25-Nov-17 | 01:41:46 | 17-3290010 | EMS Response | 140 | OC | 164 |
24-Nov-17 | 23:21:52 | 17-3280185 | EMS Response | 140 | QC | 153 |
24-Nov-17 | 23:21:52 | 17-3280185 | EMS Response | 140 | MM | 164 |
24-Nov-17 | 23:21:52 | 17-3280185 | EMS Response | 140 | OC | 164 |
<colgroup><col span="2"><col><col><col><col><col></colgroup><tbody>
</tbody>