I went to the source code of wordle & copied all 12000 words to an excel sheet Column A, starting from row 4.
3rd row for next 18 columns has drop down filter.
You guess any word with at least 2 vowels, if 3 better, no repeat letters. You get some grey, some yellow, some maybe green.
2nd column to 6th column on excel sheet is the Grey Letters, Not Found in Answer. In this, 2nd row, if u find any grey you type it here. The formula from row 4 downwards in this group checks if its top input cell is empty, if yes, true, if not empty, then it check if that letter exists in its row cell of column A. If exists, false (grey means no letter), otherwise true.
Column 7th to 11 are yellow. Same thing, row 2 gets input, 4th row onwards checks if this exists in Column A cell, true, otherwise false. If input cell empty, then True.
Column 12 to 16 gets green letter input. Here input goes by position, if 2nd letter is green, you type it in 2nd column of this group, which is 13th column.
Formula in 4th and next checks if input empty, true, otherwise if input exist in exact position, true, otherwise false.
17th column is empty & narrow, to create a gap.
18th column returns 0 if any false found in while row. Any false means this word is not the answer. Otherwise returns 1.
A separate one cell counts all those 1, tells me how many potential answers are. After every try/word, one can filter this last column on 1.