Most Common Accuring Text within a Data Set within a Time Period

[vew32]

I have a Data Table called FTCF with a number of columns one is called Date another Other Comments and Suggestions

Please Login or Register  to view this content.

to find the most occurring text with in Other Comments and Suggestions i used the below and it works perfectly with alt+ctrl+Enter to get it to calculate

Please Login or Register  to view this content.

this is the overall view i want to get a date period of last 3 months so joining a code from earlier in the project which i had help with from here

Please Login or Register  to view this content.

i made this

Please Login or Register  to view this content.

it does not work i get #Value error

so i tried

Please Login or Register  to view this content.

which returns "0" its should be text string

your thoughts please anything will do as it might trigger an event which leads me to the answer thanks

[Haseeb Avarakkan]

Try this with CTRL+SHIFT+ENTER,

Please Login or Register  to view this content.

[vew32]

Try this with CTRL+SHIFT+ENTER,

Please Login or Register  to view this content.

this works brilliantly thanks Haseeb A

When there is no data in the time frame the above returns an error #N/A so i modified the above to account for there being no Data in the time period so it will not show an error but instead "No Data"

Please Login or Register  to view this content.

CTRL+SHIFT+ENTER to finish