Hi forum,
I'm trying to come up with a formula for the above.
I have a range of cells A1:A100 and each cell can have differing string lengths. I need to count the number of times the string length of each cell is greater than X. Lets say in cell B1 the value of X is stored.
I did try COUNTIF in combination with LEN , but couldn't get this to work
Many thanks
David
Bookmarks