Top 5 Mutilpe 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 is that possible, without using a pivot table. as I need to track the last 12 weeks of top 5 words.


Thanks

 

[AliGW]

Anything is possible in theory! Could you provide a selection of sample data with expected outcomes?

 

[Raj1313]

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
Apple	15/12/2016
Orange	15/12/2016
Apple	15/12/2016
Banana	15/12/2016
Plum	15/12/2016
Plum	10/12/2016
Plum	10/12/2016
Banana	10/12/2016
Orange	10/12/2016
Pear	10/12/2016
Pear	15/12/2016
Peach	15/12/2016
Peach	15/12/2016

<tbody>
</tbody>

 

[Raj1313]

Test data above imagine there are over 20 diff fruit types. and I need the top 5 most common fruits on each date.

 

[Raj1313]

any ideas guys? - the above test data also contains blanks aswell in the fruit column.