Quote Originally Posted by Haseeb A View Post
Try this with CTRL+SHIFT+ENTER,

=INDEX(FTCF[Other Comments and Suggestions],MODE(IFERROR(IF(FTCF[Date]>=A98,IF(FTCF[Date]<C98,MATCH(FTCF[Other Comments and Suggestions],FTCF[Other Comments and Suggestions],0)*{1,1})),"")))
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"

=IFERROR(INDEX(FTCF[Other Comments and Suggestions],MODE(IFERROR(IF(FTCF[Date]>=A98,IF(FTCF[Date]<C98,MATCH(FTCF[Other Comments and Suggestions],FTCF[Other Comments and Suggestions],0)*{1,1})),""))),"No Data")
CTRL+SHIFT+ENTER to finish