LinkBack URL
About LinkBacks
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!
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!
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....
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Try this Results in sheet "Output" (starting "B9"), based on dates in sheet "Output"."C6 & E6"
Regards Mick
Please Login or Register to view this content.
HelloSixthsense
Both solution are perfect for me, I would like to say thank you for your kind help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks