Create sets of word patterns

[makinmomb]

Formula on f2 g2 h2 i2

f2 where a3 has any of these THREE DLNTRSG letters plug y otherwise N
f2 where a3 has any of these TWO DLNTRSG letters plug y otherwise N
f2 where a3 has any of these ONE DLNTRSG letters plug y otherwise N
f2 where a3 has any of these ZERO DLNTRSG letters plug y otherwise N

Find file attached

I have plugged results of the first row

[JohnTopley]

My curiosity: what is the point of all these "Scrabble" conundrums ?

And what result do want is any letter e,g "D" occurs more than once

[makinmomb]

You will not understand , long story , a scrabble tournament is worth 15,ooo USD , the dictionary thus you have to break it up into patterns of study against tile distribution , thus dont further ask me why I am asking , it is my wish to ask , there is some hidden maths that u will not understand , some golden to rule to WIN , the dictionary is damn long , thus u have make sets of likely you will pick , why does Sintek who answers such threads not questions

[nick.williams]

Try in F3:

=IF(SUM(IF(ISNUMBER(FIND(MID(F$2,SEQUENCE(LEN(F$2)),1),$A3)),1,0))=F$1,"Y","N")

Though John's question about how you want to count multiples is relevant. This counts only once for each letter so e.g. searching for "B" in "CABBALA" would return 1. If that's meant to return 2 then please let us know.

[Glenn Kennedy]

I think I understand....


=IF(SUM(MMULT(--(MID($A3,SEQUENCE(7),1)=TRANSPOSE(MID(F$2,SEQUENCE(7),1))),SEQUENCE(7)^0))=F$1,"Y","N")

[AliGW]

There won't be much left once you have distributed winnings to all those of us here who have helped you when you win ... Is that why you don't want to tell us?

thus dont further ask me why I am asking

Don't try to dictate what can and can't happen here: you are not in charge. It's perfectly OK for anyone to ask you anything about what you are doing. Thank you.

[JohnTopley]

Removed by JT

[makinmomb]

My scrabble questions should end this month , than likely I am chasing the WORLD CHAMPION whose job is scrabble , I do a job and wona switch to scrabble on part time

[Glenn Kennedy]

Ignore my reply. It's wrong (again). I have Covid right now... I think I should stay away from EF... I'm making too many errors!!

[makinmomb]

Glenn always understand me close , thank you