L
Loralei
I have a range of cells with values that are 5 or 10 numbers long that start
with 11, 12 or 13. What function do I use to tell Excel to count only the
cells which value starts with 11? I do not want to sum, only count the number
of cells that have values starting with 11. Again, the values can be 5
digits, as in 11222 or 10 digits such as 1122222222. I only want Excel to
return the number of values that start with 11 regardless of how long the
digit actually is.
with 11, 12 or 13. What function do I use to tell Excel to count only the
cells which value starts with 11? I do not want to sum, only count the number
of cells that have values starting with 11. Again, the values can be 5
digits, as in 11222 or 10 digits such as 1122222222. I only want Excel to
return the number of values that start with 11 regardless of how long the
digit actually is.