# Top 5 Multiple Criteria

#### Raj1313

##### Board Regular
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

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
What date and what is expected output on that date?

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

Replies
4
Views
320
Replies
6
Views
595
Replies
26
Views
776
Replies
2
Views
403
Replies
5
Views
441

1,196,250
Messages
6,014,236
Members
441,808
Latest member
xplainer

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back