Hello Excel experts,
I have the following table:
(A) Date ||| (B) ID
(1) 20/10/2019 ||| 12345
(2) 20/10/2019 ||| 54321
(3) 20/10/2019 ||| 43251
(4) 20/10/2019 ||| 12345
(5) 19/10/2019 ||| 11111
(6) 19/10/2019 ||| 22222
(7) 19/10/2019 ||| 33333
(8) 19/10/2019 ||| 44444
And I would like to count the unique IDs per date on that table, getting as result something like this:
Date ||| Unique count of IDs
20/10/2019 |||| 3
19/10/2019 |||| 4
Any help? Can't make it work by myself using google's help.
Bookmarks