Scrabble Value calculation for Welsh words


Joined
Oct 19, 2021
Messages
1
Reaction score
0
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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top