please look at this file
formula on a2 and b2 down to give me those results
a2 = seven letter words
b2 = eight letter words
both dic pasted on e and f
ask the formula to search at 55000 rows that is how long the dictionary
Find File attached
thank you
Hi,
in A2: =SORT(UNIQUE(FILTER(E:E,LENGTH(E:E)=7)))
in B2: =SORT(UNIQUE(FILTER(F:F,LENGTH(F:F)=8)))
br, Alexandra
Hi makinmomb,
See if this formula can help..
Formula:
Please Login or Register to view this content.
It searches for each letter and turns to TRUE if each letter is present in each word. See the attached..
If you were using Excel 365 there might be a much easier way..
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Hi cysu11,
I don't think his Excel 2013 has the Unique() or Filter() functions yet..I may be wrong.
Hi MarvinP,
yes, yor´re right. I forgot to look, about the version of Excel. Maybe now it´s a new version for him/her at work!
br, Alexandra
I will still keep the thread open for someone to try formula on a2 and b2 drag down
Marvin Thank you sorts the matter indirectly , good trick
Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
If you were using Excel 365 this formula in H1 (just a single cell) would work. Then pull the formula to the right and it works for Dic2.
Formula:Please Login or Register to view this content.
Better still would allow any letters to be put into A1 and B1. This formula using Excel 365 will update the answers automatically.
Formula:Please Login or Register to view this content.
Thank you JT and MarvinP working as intended
JT it processed a dictionary of 1oo,ooo words at less than 3 seconds
JT check why it does not process here
Was expecting these on 7 for elleri
reallie
libeler
dellier
helleri
hellier
leisler
rellies
treille
eviller
leerily
Try
Please Login or Register to view this content.
Last edited by JohnTopley; 04-02-2025 at 03:53 AM.
working partially correct gives extras not required
REALLIE
EARLIER
LEARIER
ARRIERE
LAIRIER
RALLIER
LIBELEE
BEERIER
LIBELER
BRILLER
REEDIER
DELLIER
DILLIER
DRILLER
REDRILL
REFEREE
REEFIER
FLEERER
EELLIKE
REEKIER
SEELIER
RELIEVE
PEERIER
RETIREE
REVERIE
LEVELER
REELERS
REVELER
REVERER
FEIRIER
FIERIER
REIFIER
FERLIER
HELLERI
HELLIER
VEILIER
RIVIERE
LEISLER
RELLIES
TREILLE
EVILLER
LEERILY
REPLIER
RELIERS
RELIVER
REVILER
MERRIER
PERRIER
RETIRER
TERRIER
FIRRIER
FRILLER
GIRLIER
GRILLER
HILLIER
RILIEVI
MILLIER
SILLIER
TILLIER
MIRLIER
NIRLIER
ROILIER
TRILLER
LORRELL
reallie is correct
lorrell is not correct , elleri does not have an o
it should give the following only
reallie
libeler
dellier
helleri
hellier
leisler
rellies
treille
eviller
leerily
See attached ...
JT working as intended if , closed the thread
Last edited by makinmomb; 04-08-2025 at 12:03 PM. Reason: CLOSE
JT cannot award reputation to the same person more than once consecutively
No problem ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks