10 most common values between two dates

[Villalobos]

Hello,

I would like to ask some help from you, I can find the 10 most common values in the whole date range, just I do not know how to do this between two unique dates.

Please, could somebody tell me how should I do this?
I attached the sample file.



Thanks in advance the reply!

[ramananhrm]

Please try this solution

[daddylonglegs]

You can do that in essentially the same way you were doing it, just adding the date conditions into the MODE function - in F6

=MODE(IF(Date>=Startdate,IF(Date<=Enddate,Product)))

confirmed with CTRL+SHIFT+ENTER

and then in F7 copied down to F15

=MODE(IF(COUNTIF(F$6:F6,Product)=0,IF(Date>=Startdate,IF(Date<=Enddate,Product*{1,1}))))

also confirmed with CTRL+SHIFT+ENTER

That will give you the products that appear within your specified date range in order of frequency, see attached

[Villalobos]

Hello ramananhrm,

This is what I wanted, thank you for your help.
I would have one more question, I hope not a big problem.
How should to do that I would like that the highest "Count" product would be in the first postion and so down the others?

[Villalobos]

Hello daddylonglegs,

Your solution solved my sorting problem also, thank you!