Display and count unique values in date range

[alfik1]

Hi all,

Im standing in front of the task (see picture attached) and I cannot to figure it out . Does anybody has idea how to achieve desired result based on the criterias defined?
The result should be done by fromula, not by pivot or vba. If possible, do not use any formula in data table...
Im using excel 2016
Many thanx for any idea

 

[Marcelo Branco]

Substitute in the formula E$4 and E$5 by Sheet2!E$4 and Sheet2!E$5 respectively (adjust the sheet name and cells ref)

M.

 

[alfik1]

Yes thats what I did, but something is not ok (name of sheet and cell references are ok):

 

[Marcelo Branco]

It's hard to help with this picture

It worked perfectly for me with the dates on another sheet.

Sheet SUPPevalNumb

[TABLE="class: grid"]
<tbody>[TR]
[TD="bgcolor: #DCE6F1"][/TD]
[TD="bgcolor: #DCE6F1"]

K​

[/TD]
[TD="bgcolor: #DCE6F1"]

L​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

8​

[/TD]
[TD]

From​

[/TD]
[TD]

To​

[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]

9​

[/TD]
[TD]

01/02/2018​

[/TD]
[TD]

10/02/2018​

[/TD]
[/TR]
</tbody>[/TABLE]


Helper
K3 copied down
=IF(A3="","",IF(COUNTIF(A$3:A3,A3)=1,COUNTIFS(A$3:A$100,A3,B$3:B$100,">="&SUPPevalNumb!K$9,B$3:B$100,"<="&SUPPevalNumb!L$9),""))

Re-check the sheet name, cells ref, etc, etc...

M.

 

[alfik1]

Hi Marcelo,

its working now (to be honest, I dont know where was a problem), I copied your formula and its working.
Many thanx, I see that your excel skills are excellent. Well done. Bravo!