J
JCameron
I currently have a cell with the current definition:
=COUNTIF(E9:E200,">1000")
which yeilded the number of cells that have a value greater than 1000. Now
the data in this field has been changed to an alpha numeric string and I
would like to change the COUNTIF to count the number of cells where the
string length is equal to 4 characters. I have tried various things like:
COUNTIF(E9:E200,"LEN($)=4")
whith no luck. Any suggestions or solutions would be appreciated.
JCameron
=COUNTIF(E9:E200,">1000")
which yeilded the number of cells that have a value greater than 1000. Now
the data in this field has been changed to an alpha numeric string and I
would like to change the COUNTIF to count the number of cells where the
string length is equal to 4 characters. I have tried various things like:
COUNTIF(E9:E200,"LEN($)=4")
whith no luck. Any suggestions or solutions would be appreciated.
JCameron