In Excel, Judge Whether A Word Has Duplicate Letters

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)

Explanation:

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.

Comments

[Judith-Excel-Sharing]

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

[Judith-Excel-Sharing]

In addition, feel free to ask away any Excel-related questions. We are here to help🙌🏻 discord.gg/hgbKEvJ4 & reddit.com/r/esProc_Desktop/