Forum Discussion
Solved
Help with an Excel formula (numerical array)
I'm looking for a way for a formula to multiply the value of a cell based on the count of the numbers within it. For example, the formula now takes the dollar value in one cell X quantity of anot...
Hi,
If I understood correctly the task is to calculate the number of digits in the text where could be from 1 to 4 digits separated by commas, like this
That could be classical formula (column B)
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1
or for your case bit shorter one (column C)
=INT(LEN(A1)/2)+1
and attached
Hi,
If I understood correctly the task is to calculate the number of digits in the text where could be from 1 to 4 digits separated by commas, like this
That could be classical formula (column B)
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1
or for your case bit shorter one (column C)
=INT(LEN(A1)/2)+1
and attached
Yes, that was exactly what I was looking for. Thank you!
You are welcome
