Extract unique values between two dates and count their frequency

[Villalobos]

Hello,

I would like to ask some help how to extract unique values between two dates from table and count their frequency also.
The pivot table function is not allowed.

I have attached a sample file with an example output.



Thanks in advance the help!

[:) Sixthsense :)]

In J6 Cell of

=IF(AND([@Date]>=Output!$C$6,[@Date]<=Output!$E$6),[@Product],"Product")


In B9 Cell of Output Sheet

=IFERROR(INDEX(Táblázat1[Product],MATCH(0,COUNTIF($B$8:B8,Táblázat1[Column1]),0)),"")


In C9 Cell of Output Sheet

=COUNTIFS(Táblázat1[Column1],Output!B9)


Drag all the formula's down....

[MickG]

Try this Results in sheet "Output" (starting "B9"), based on dates in sheet "Output"."C6 & E6"

Please Login or Register  to view this content.

Regards Mick

[Villalobos]

Hello Sixthsense and MickG,

Both solution are perfect for me, I would like to say thank you for your kind help!