Top 5 Multiple Criteria

[Raj1313]

Hi,

I have a list of words in Column A over (10,000 rows) - I have a list of dates in Column B.

I need to find the top 5 most common words on certain dates. Column A also contains blanks which also needs to be counted as part of the top 5.

Sample Data below:

Orange	13/12/2016
Orange	13/12/2016
Orange	13/12/2016
Orange	13/12/2016
Plum	15/12/2016
Banana	13/12/2016
Apple	15/12/2016
	15/12/2016
Orange	15/12/2016
Apple	15/12/2016
Banana	15/12/2016
	15/12/2016
Plum	10/12/2016
Plum	10/12/2016
Banana	10/12/2016
	10/12/2016
Pear	10/12/2016
Pear	15/12/2016
Peach	15/12/2016
Peach	15/12/2016
Banana	13/12/2016
Apple	15/12/2016
	15/12/2016
Orange	15/12/2016
Apple	15/12/2016
Banana	15/12/2016
Plum	15/12/2016

<colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="102" style="width: 77pt; mso-width-source: userset; mso-width-alt: 3730;"> <tbody> </tbody>

Thanks

 

[Aladin Akyurek]

What date and what is expected output on that date?

 

[Raj1313]

What date and what is expected output on that date?

The date would be the previous- as this would be on rolling 6 week basis.

So I would have a list of dates in a row, underneath I would want to see the top 5 for that day if that makes sense