| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting
One way:
=CEILING(A1/10,1) In article , 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?? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting
=ROUNDUP(A1/10,0)
Tim made a mistake "Tim879" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting help | Excel Worksheet Functions | |||
| Counting | Excel Discussion (Misc queries) | |||
| Re counting | Excel Worksheet Functions | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Linear Mode
