Auto- Calculate values of text strings

Gesyca_is_joy · Nov 20, 2017

ok i have a similar question that I can't find the answer to.

Say i have a list in my sheet "Value" and it gives a value for every letter in the alphabet in a list setup across two columns, the letters of the alphabet in Column A (Rows 1-26) and their corresponding values in Column B, rows 1-26. (Shown Below) then in column D i have a list of words, and in column E i want to determine the value of that word based on the value of the letters in my list; how would i write that formula?

an example would be the word "Blue" would have a value of 7 (B=3, L=1, U=2, E=1), but i want to write a formula so that i can add more words to my list in column D and just drag the formula down to auto-calculate the value.

[TABLE="width: 87"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Letter[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]I[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]J[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]K[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]N[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]O[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Q[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]R[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]S[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]T[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]U[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]V[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]W[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Z[/TD]
[TD="align: right"]6

[/TD]
[/TR]
</tbody>[/TABLE]

Eric W · Nov 20, 2017

Looks very scrabbly - maybe:

	A	B	C
Letter	Value	Word	Value
A	BLUE
B	red
C	ALLIGATOR
D	Cat
E	HORSE
F	JACKAL
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z

<colgroup><col style="width: 25pxpx"><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]

[TD="align: right"]7[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"][/TD]

[TD="align: right"]3[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]

[TD="align: right"]10[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]

[TD="align: right"]4[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]

[TD="align: right"]5[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]

[TD="align: right"]14[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]#REF![/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]#REF![/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: right"]4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>

Sheet4

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]E2[/TH]
[TD="align: left"]{=SUM(SUBTOTAL(9,OFFSET($B$2,CODE(MID(UPPER(D2),ROW(INDIRECT("1:"&LEN(D2))),1))-65,0)))}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

This works for upper/lower case. Hope this helps.

JoeMo · Nov 20, 2017

As an alternative, here's a UDF.
To install the UDF:
1. With your workbook active press Alt and F11 keys. This will open the VBE window.
2. In the project tree on the left of the VBE window, find your project and click on it.
3. On the VBE menu: Insert>Module
4. Copy the UDF from your browser window and paste it into the white space in the VBE window.
5. Close the VBE window and Save the workbook. If you are using Excel 2007 or a later version do a SaveAs and save it as a macro-enabled workbook (.xlsm file extension).
6. Use the UDF as you would any native Excel function (see example below).
7. Make sure you have enabled macros whenever you open the file or the code will not run.

Code:

Function SumAlphas(S As String, lkupTable As Range) As Variant
'lkupTable assigns values to each letter in the alphabet
Dim i As Long
For i = 1 To Len(S)
    If Mid(S, i, 1) Like "[A-Za-z]" Then
        SumAlphas = SumAlphas + WorksheetFunction.VLookup(Mid(S, i, 1), lkupTable, 2, 0)
    End If
Next i
End Function

Sheet7

	A	B	C	D	E
A		Blue
B		John and Me
C		Red
D		JohnJohn
E		too
F		Mississippi
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:20px;"><col style="width:14px;"><col style="width:38px;"><col style="width:85px;"><col style="width:21px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]7[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]14[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]16[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]16[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]0[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]

[TD="align: right"]5[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]

[TD="align: right"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]

[TD="align: right"]2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]15[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]16[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]17[/TD]

[TD="align: right"]6[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]18[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]19[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]20[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]21[/TD]

[TD="align: right"]2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]22[/TD]

[TD="align: right"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]23[/TD]

[TD="align: right"]2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]24[/TD]

[TD="align: right"]5[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]25[/TD]

[TD="align: right"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]26[/TD]

[TD="align: right"]6[/TD]

</tbody>

Spreadsheet Formulas

Cell	Formula
E1	=SumAlphas(D1,$A$1:$B$26)

EDIT: Forgot to add that you are not limited to single words in a cell with this.

Excel tables to the web >> Excel Jeanie HTML 4 EDIT

Gesyca_is_joy · Nov 20, 2017

you are all awesome!!

Ok, so I am trying to balance the letter value based on real-time counts and frequency that update as I add words to my master list; I have all those formulas written and working. Now what i'm trying to write is a formula that will assign a letter value between 1-6 based on the frequency percentage, see below, I want the value in Col D to be a number between 1 and 6 based on the percentage in Col C. So if the percentage is 0%, i want the value to be 6; if the percentage is 1% the value is 5, 2-3% value is 4, 5-6% value is 3, 7-9%, value is 2 and anything above 9% gets a value of 1. I figured i could use a series of nested IF THEN statements, but that only worked if i used absolute values; when i needed a range of percentages to get the same value i kept getting errors... i thought about using a little table of % values and making a reference, but then i couldn't make a statement like "everything above 9% is a value of 1".

[TABLE="width: 228"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Col A[/TD]
[TD]Col B[/TD]
[TD]Col C[/TD]
[TD]Col D[/TD]
[/TR]
[TR]
[TD]Letter[/TD]
[TD]Count[/TD]
[TD]Frequency (%)[/TD]
[TD]Value[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]8%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]3%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]47[/TD]
[TD="align: right"]14%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]2%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]5%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]5%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]J[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]K[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]5%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]2%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]N[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]7%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]O[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]9%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]3%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Q[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]R[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]5%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]S[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]4%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]T[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]9%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]U[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]4%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]V[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]W[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]5%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]3%[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Z[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0%[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

JoeMo · Nov 20, 2017

What value do you want assigned if Frequency is between 0% and 1%, between 1% and 2%, between 3% and 5%, between 6% and 7%??

Gesyca_is_joy · Nov 20, 2017

All the % are whole numbers because they are derived from a straight character count, there is no partial numbers involved in the calculation

0% = 6
1% = 5
2% = 4
3% = 3
4% = 3
5% = 2
6% = 2
7% = 1
8% = 1
9% = 1
10% and up = 0

JoeMo said:
What value do you want assigned if Frequency is between 0% and 1%, between 1% and 2%, between 3% and 5%, between 6% and 7%??

JoeMo · Nov 20, 2017

Here's a nested IFs formula - copy D2 down.

Excel Workbook

A

B

C

D

1

Letter

Count

Frequency (%)

Value

2

A

28

8%

1

3

B

6

2%

4

C

4

1%

5

D

11

3%

3

6

E

47

14%

0

7

F

4

1%

5

8

G

7

2%

4

9

H

17

5%

2

10

I

17

5%

2

11

J

1

0%

6

12

K

5

1%

5

13

L

19

5%

2

14

M

8

2%

4

15

N

25

7%

1

16

O

31

9%

1

17

P

9

3%

3

18

Q

0

0%

6

19

R

19

5%

2

20

S

14

4%

3

21

T

30

9%

1

22

U

13

4%

3

23

V

2

1%

5

24

W

19

5%

2

25

X

0

0%

6

26

Y

11

3%

3

27

Z

0

0%

6

Sheet8

Gesyca_is_joy · Nov 20, 2017

OMG... I can't believe i didn't do <= on that last IF statement...

Gesyca_is_joy · Nov 20, 2017

Ok, last ask; how do i calculate the sum total of appearances for letters in a given word based on a set list? so the word ALL (not case sensitive though) would return a value of 18 in this example? I'm thinking it's a SUMIF formula, but i can't figure out how to make the calculation consider each character individually to add each number assigned to that character.

[TABLE="width: 131"]
<tbody>[TR]
[TD]Letter[/TD]
[TD]Appearances[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]E[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD]F[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]G[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]H[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]I[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]J[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]K[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]M[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]N[/TD]
[TD="align: right"]7[/TD]
[/TR]
[TR]
[TD]O[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD]P[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD]Q[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]R[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]S[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]T[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD]U[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]V[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]W[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]X[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Y[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Z[/TD]
[TD="align: right"]0[/TD]
[/TR]
</tbody>[/TABLE]

Eric W · Nov 20, 2017

Isn't that essentially the same as your question in post 1, just with a different table? If so, the formula from post 2 should work.

Auto- Calculate values of text strings

Gesyca_is_joy

Board Regular

Excel Facts

Eric W

MrExcel MVP

JoeMo

MrExcel MVP

Gesyca_is_joy

Board Regular

JoeMo

MrExcel MVP

Gesyca_is_joy

Board Regular

JoeMo

MrExcel MVP

Gesyca_is_joy

Board Regular

Gesyca_is_joy

Board Regular

Eric W

MrExcel MVP

Similar threads

Forum statistics

Share this page

Auto- Calculate values of text strings

Board Regular

Excel Facts

MrExcel MVP

MrExcel MVP

Board Regular

MrExcel MVP

Board Regular

MrExcel MVP

Board Regular

Board Regular

MrExcel MVP

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock