I'm finding if there at least one cell with the first character equal to "!"
Formula I have used without success:
Why doesn't it work? And what do I have to change in the formula to make it work as intended?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row. For example, look up an employee's last name by her employee number, or find her phone number by looking up her last name (just like a telephone book).
You just need a count, not a lookup.
COUNTIF with a wildcard character.
Or to make it a condition,