Counting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I really need help here.

I need to count how many times a number or portion of that number is in a
specific cell. IE: A1 is 101 I need to know how many times 10 or a portion
of 10 is in that number. The answer in this case would be 11. If the
value of A1 is 90 the answer would be 9.

Can anyone help??
 
Try this formula to see if you get what you need.

=ROUNDDOWN(A1/10,0)
Value Result
901 90
101 10
10 1
999 99
 
Back
Top