How to solve wordle using excel

preview_player
Показать описание
=IF(C7=0,A2:A12948,FILTER(A2:A12948,ISNUMBER(BYROW(SEARCH(MID(C7,SEQUENCE(,LEN(C7)),1),A2:A12948),SUM))))

=FILTER(C9#,BYROW(IFERROR(SEARCH(MID(E7,SEQUENCE(,LEN(E7)),1),C9#),0),SUM)=0)

=IF(F7=0,E9#,FILTER(E9#,IFERROR(SEARCH(F7,E9#,F6),0)=F6))

=WRAPROWS(Sheet1!J9#,5,"")

List of words:
Рекомендации по теме
Комментарии
Автор

Keep up the fantastic work. A tutorial that is very different from other ones. Many excel tutorials are business related. Useful but not the only application of excel

patrickschardt