ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Solver - Assign values to Letters of the Alphabet (https://www.excelbanter.com/excel-discussion-misc-queries/122628-solver-assign-values-letters-alphabet.html)

GeoJack

Solver - Assign values to Letters of the Alphabet
 
I have a puzzle to solve and have been trying for a while now.

Each letter of the alphabet is valued between 1 - 26.

I have a list of 20 names. (Some have double letters in them such as
Barrett)

Each name has a known value based on the sum of it's letter values. (eg
Barrett MAY be 3+7+2+2+6+10+10 = 40 but I only know the total, NOT the
individual letter values)

Each value of 1 - 26 can only be used once for A - Z.

Requirement - Assign each letter of the alphabet a value between 1 & 26
to give the correct name value. Each letter value is to be used only
once.

Any help would be GREATLY appreciated.



All times are GMT +1. The time now is 06:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com