Hey,
I need a function that:
Checks if a word in a cell contains a given letter, e.g.:
If in A1="KcJh3d" there is a K and J and 3, then in B1="HML",
If in A2="9c8h2d" there is a K and J and 3, then in B1="MML".
I have column A and an array. I want zaby in column B to assign values such as HML or MML to column A.
ps I want to group the types of common cards in poker. The column is the possible common cards and HML etc are their groupings. H = high, M = mid, L = low.
Translated with www.DeepL.com/Translator (free version)
I need a function that:
Checks if a word in a cell contains a given letter, e.g.:
If in A1="KcJh3d" there is a K and J and 3, then in B1="HML",
If in A2="9c8h2d" there is a K and J and 3, then in B1="MML".
I have column A and an array. I want zaby in column B to assign values such as HML or MML to column A.
ps I want to group the types of common cards in poker. The column is the possible common cards and HML etc are their groupings. H = high, M = mid, L = low.
Translated with www.DeepL.com/Translator (free version)