Find The Most Frequent Occurring Text In A Column

[Shukis7]

Hi,

I want to find the most frequent occurring text in a column with multiple criteria. I know how to do this for simple criteria, but when I have to use the date criteria it gets complicated.

This is working for these two criteria that I implemented.
=INDEX(All!$G$2:$G$119285,MODE(IF(All!$F$2:$F$119285 = Analysis!A4,IF(All!$AO$2:$AO$119285 = Analysis!$A$2,MATCH(All!$G$2:$G$119285,All!$G$2:$G$119285,0)))))

This is the formula that I use for finding the most occurring text in a column, with the date range as criteria:
=INDEX(All!$G$2:$G$119285, MATCH(MODE.SNGL(IF((All!$AY$2:$AY$119285<=$A$12)*(All!$AY$2:$AY$119285>=$A$11), COUNTIF(All!$G$2:$G$119285, "<"&All!$G$2:$G$119285), "")), COUNTIF(All!$G$2:$G$119285, "<"&All!$G$2:$G$119285),0))

Both of them are working fine, but I have trouble "combining" these two.

Any help would be appreciated.

Thank you!

 

[Fluff]

Can you post some sample data from both sheets, along with expected results?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.