Hi. I am trying to count how many different purchase orders that I have for different dates. So if I have a duplicate number on the same date i want it to count as 1 but where the number are in different dates ir
my data is basically
col a. Col b
456. 01/01/21
674 02//04/21
567 03/02/21
674. 02/04/21
334. 02/04/21
567. 06/04/21
so basically I’d expect my count to be
456. 1
674. 1
567. 2
334 1
my data is basically
col a. Col b
456. 01/01/21
674 02//04/21
567 03/02/21
674. 02/04/21
334. 02/04/21
567. 06/04/21
so basically I’d expect my count to be
456. 1
674. 1
567. 2
334 1