Hi,
I'm trying to make a worksheet that calculates the scrabble value of some Welsh words. I found an excel spreadsheet solution for English scrabble which I've pasted below, but the problem I've got is that Welsh scrabble has double letters like ff that have a separate value to f...is there a way to make a formula take that into account?
Values for Welsh scrabble
a 1
b 3
c 4
ch 5
d 1
dd 1
e 1
f 2
ff 4
g 2
ng 10
h 4
i 1
j 10
l 2
ll 5
m 3
n 1
o 1
p 5
ph 10
r 1
rh 10
s 3
t 3
th 4
u 2
w 1
y 1
Thanks!
Earlier solution for English scrabble
------
Put this table in G1:H26
A 1
B 3
C 3
D 2
E 1
F 4
G 2
H 4
I 1
J 8
K 5
L 1
M 3
N 1
O 1
P 3
Q 10
R 1
S 1
T 1
U 1
V 4
W 4
X 8
Y 4
Z 10
Then....for a word in A1
This formula calculates its scrabble value
B1:
=SUMPRODUCT(LOOKUP(MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1)),1),$G$1:$G$26,$H$1:$H$26))
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP
I'm trying to make a worksheet that calculates the scrabble value of some Welsh words. I found an excel spreadsheet solution for English scrabble which I've pasted below, but the problem I've got is that Welsh scrabble has double letters like ff that have a separate value to f...is there a way to make a formula take that into account?
Values for Welsh scrabble
a 1
b 3
c 4
ch 5
d 1
dd 1
e 1
f 2
ff 4
g 2
ng 10
h 4
i 1
j 10
l 2
ll 5
m 3
n 1
o 1
p 5
ph 10
r 1
rh 10
s 3
t 3
th 4
u 2
w 1
y 1
Thanks!
Earlier solution for English scrabble
------
Put this table in G1:H26
A 1
B 3
C 3
D 2
E 1
F 4
G 2
H 4
I 1
J 8
K 5
L 1
M 3
N 1
O 1
P 3
Q 10
R 1
S 1
T 1
U 1
V 4
W 4
X 8
Y 4
Z 10
Then....for a word in A1
This formula calculates its scrabble value
B1:
=SUMPRODUCT(LOOKUP(MID(A1,ROW($A$1:INDEX($A:$A,LEN(A1),1)),1),$G$1:$G$26,$H$1:$H$26))
Is that something you can work with?
***********
Regards,
Ron
XL2002, WinXP