Problem dscription & analysis:
In the following column, each cell contains a word and certain words have duplicate letters:
If a word has duplicate letters, display NOGOOD in the right cell; if it hasn’t, display GOOD in the cell:
Solution:
Use SPL XLL to enter the following formula and drag it down:
=spl("=d=?.split(),if(d.icount()==d.count(),$[GOOD],$[NOGOOD])",A1)
split()function splits a string according to unique letters. icount() function counts unique letters in a word. count() function calculates the number of unique letters in all the words.
Top comments (2)
Please do not hesitate to try this Excel booster! It's FREE now! Here are the useful links you may need:
🧊SPL download address: scudata.com/download-Desktop
🧊Plugin Installation Method: c.scudata.com/article/1652061135502
🧊References to other rich Excel operation cases: c.raqsoft.com/article/1651916536524
In addition, feel free to ask away any Excel-related questions. We are here to help🙌🏻 discord.gg/hgbKEvJ4 & reddit.com/r/esProc_Desktop/