I am making a research template, and I have come across a problem while trying to code. I have cells which have "?", stating that they are "to be researched". But, some of them have more than one question mark, and I would like to be able to know if the cell starts with "?". How do I figure out how many cells start with a question mark in a range? Anything will help. :)
Please try:
=countif(range,"~?*")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With