Hi team,
I need a little help with a forumula...
Basically I'm trying to find the number of occurences a specific string of text there is in a specific Range....the problem is that the string I'm looking for is not the only string in those ranges ... I'm looking for the "9777" String but in a range you would read "9777 installation booked for X date"
I'm using this formula that's givint me zeros
=COUNTIF(M14:M31;LEFT("9777";4))
Thanks for the help!
Cheers,
Bookmarks