T
tralls
I'm plagued by a problem where a simple solution likely exists, yet I
can't seem to unearth it. I am trying to capture the count of a text
string in one column with variable locations (preferrably through
consolidated formulas); as follows:
------- Column A
Row 1 | one two three
Row 2 | two one
Row 3 | one three one
Row 4 | three two three
Row 5 | one
The desired result would provide the following:
one = 5
two = 3
three = 4
I don't have the option of separating the text out with
text-to-columns. Thank you in advance for your shared wisdom!
can't seem to unearth it. I am trying to capture the count of a text
string in one column with variable locations (preferrably through
consolidated formulas); as follows:
------- Column A
Row 1 | one two three
Row 2 | two one
Row 3 | one three one
Row 4 | three two three
Row 5 | one
The desired result would provide the following:
one = 5
two = 3
three = 4
I don't have the option of separating the text out with
text-to-columns. Thank you in advance for your shared wisdom!