Hello all,
Thank you for the forum this is great and have utilised it many times on my journey to better work with excel. I am using excel version 2013
My Dilema is:
I have developed the formula "=countifs(V2:V5447,"VIC",M2:M5447,"*Sept*")
Cell format for Column "M" is date format
Cell format for Column "V" is general
The resultant output of the formula is"0"
I have changed the Format of Column "M" to general and entered the dates as a TXT rather than Date and the resultant outcome is still "0"
Can someone shed any light for me
thanks
Chris
Thank you for the forum this is great and have utilised it many times on my journey to better work with excel. I am using excel version 2013
My Dilema is:
I have developed the formula "=countifs(V2:V5447,"VIC",M2:M5447,"*Sept*")
Cell format for Column "M" is date format
Cell format for Column "V" is general
The resultant output of the formula is"0"
I have changed the Format of Column "M" to general and entered the dates as a TXT rather than Date and the resultant outcome is still "0"
Can someone shed any light for me
thanks
Chris