DEV Community

Cover image for In Excel, Judge Whether A Word Has Duplicate Letters
Judith-Excel-Sharing
Judith-Excel-Sharing

Posted on

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:

original table

If a word has duplicate letters, display NOGOOD in the right cell; if it hasn’t, display GOOD in the cell:

desired table

Solution:

Use SPL XLL to enter the following formula and drag it down:

=spl("=d=?.split(),if(d.icount()==d.count(),$[GOOD],$[NOGOOD])",A1)

Enter fullscreen mode Exit fullscreen mode

result table with code entered
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.

Top comments (2)

Collapse
 
judith677 profile image
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

Collapse
 
judith677 profile image
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/