Counting
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
On Aug 15, 1:04 pm, John wrote:
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??
--
John Chaput
|