Counting number of people per day, but not duplicates

Hi,


in the example, in H2 to be confirmed with control+shift+enter before to be copied below: the formula needs array status...

=IFERROR(SUM(IF(FREQUENCY(IF(B$2:B$100=B2,MATCH(A$2:A$10,A$2:A$100&"",0)),ROW($2:$100)-1),1)),"")


Please see the attachment

Regards

Thank you for replying. The formula works just fine. What can I do if I want to condense it to something like:

Date	# of Patiens
04/01/2019	4
04/02/2019	1
04/03/2019	1

I should have mentioned this in my original post, sorry. Thank you for being helpful.

Hi,

in K2

=IFERROR(INDEX(B$2:B$1000,MATCH(0,INDEX(COUNTIF(K$1:K1,B$2:B$1000&""),),0)),"")

to be copied down.

Please check format applied to K2 ("MM/DD/YYYY;;") to hide zeros.


In L2 to be confirmed with control+shift+enter (in the formula bar you should see formula embraced in curly brackets)

=IFERROR(SUM(IF(FREQUENCY(IF(B$2:B$1000=K2,MATCH(A$2:A$10,A$2:A$1000&"",0)),ROW($2:$1000)-1),1)),"")

or in L2 (just to be copied)

=IF(K2>0,SUMPRODUCT(1/COUNTIF(A$2:A$100,A$2:A$100&"")*(B$2:B$100=K2)),"")

should do the trick too.

Regards