A I have a long list of words (one per cell). My goal was to determine which words are made up of the same letters (e.g.
Ganglia, so repeated letters don't matter to me).
I made a formula to give each word a "score" by this system: An
a is worth 1 point, a
b is worth 2 points, a
c is worth 4 points, and so on until
z is worth 2^25 = 33,554,442 points. Words with the same score in this system must have the same letters.
My formula is long and cumbersome. It looks like:
=if(isnumber(search("A",A1)),2^0,0)+if(isnumber(search("B",A1)),2^1,0)+... and so on all the way to a term that searches for
I'm looking for help to make the formula more manageable. I thought having an array somewhere with letters in one column and their values in the adjacent column might help. But I hit a dead end on this.