thedeadzeds
Active Member
- Joined
- Aug 16, 2011
- Messages
- 442
- Office Version
- 365
- Platform
- Windows
Hi Guys,
Is there a way to do the following:
Count the unique Ref, Name and Date so the required results would show in the 'unique count' column. So the below is basically saying for example, Jim appears 5 times in the table with the same ref no but is on two different days, so essentially it is counting 1 for 01/06/19 and 1 for 02/06/19 but leaving the others blank as essentially they are duplicates. That wasy i can then use the Unique count column to sum the actual unique instances.
I hope this makes sense
<colgroup><col span="6"><col><col><col><col></colgroup><tbody>
</tbody>
Is there a way to do the following:
Count the unique Ref, Name and Date so the required results would show in the 'unique count' column. So the below is basically saying for example, Jim appears 5 times in the table with the same ref no but is on two different days, so essentially it is counting 1 for 01/06/19 and 1 for 02/06/19 but leaving the others blank as essentially they are duplicates. That wasy i can then use the Unique count column to sum the actual unique instances.
I hope this makes sense
dealer | ServCode | Tran1 | Tran2 | Tran3 | OpNum | RefNo | Name | Date | Unique Count |
CA | MOT | IBB | 527 | 1 | Dave | 01/06/19 | 1 | ||
NSK | BPOLLEN | IBB | 292 | 2 | Beth | 01/06/19 | 1 | ||
NSK | SER | ENQ | QCH | 292 | 2 | Beth | 01/06/19 | ||
CA | SER | ENQ | COD | 292 | 2 | Beth | 01/06/19 | ||
MCH | MEC | CAN | 292 | 3 | Jim | 01/06/19 | 1 | ||
MCH | MEC | CAN | 292 | 3 | Jim | 01/06/19 | |||
MCH | MEC | CAN | 292 | 3 | Jim | 01/06/19 | |||
MCH | MEC | CAN | 293 | 3 | Jim | 02/06/19 | 1 | ||
MCH | MEC | CAN | 294 | 3 | Jim | 02/06/19 | |||
NSK | MEC | W3B | QB | 292 | 4 | Jim | 01/06/19 | 1 |
<colgroup><col span="6"><col><col><col><col></colgroup><tbody>
</tbody>