Forum Discussion
want to extract certain numbers from string
i have an excel column like following and want to extract FREQUENCY OF every number e.g- frequency of PU-6 = 5 like that. thanks in advance
| PU-6, PU-7, PU-7, PU-7 |
| PU-6 |
| PU-6, PU-6 |
| PU-6, PU-7, PU-7, PU-7 |
For example:
The formula in B8 is
=SUM((LEN($A$1:$A$4)-LEN(SUBSTITUTE($A$1:$A$4,A8,""))))/LEN(A8)
- thanks
