I have word on a1 as follows
NEINIES
TESTING
I want formula on b1 to do the follow
check character 1 see if same with character 4
check character 2 see if same with character 5
check character 3 see if same with character 6
If it does the work correctly expected results will be
NEINIES MARK
TESTING
neinies b1: {=and(mid(a1, {1,2,3}, 1) = mid(a1, {4,5,6}, 1))} testing abcabc
Entia non sunt multiplicanda sine necessitate
Thank you very much shg it successfully quoted 66 words in the whole dictionary of 40,000 words
AKEAKES
ALFALFA
ARAARAS
ATAATAS
ATLATLS
BEEBEES
BERBERE
BERBERS
BONBONS
BOOBOOK
BOOBOOS
BOUBOUS
BUIBUIS
BULBULS
CANCANS
CHICHIS
CHOCHOS
DIKDIKS
DOODOOS
DUMDUMS
ENTENTE
FURFURS
GRIGRIS
GRUGRUS
HUMHUMS
JIGJIGS
KAIKAIS
KIEKIES
KINKING
KOEKOEA
KUMKUMS
LABLABS
LOGLOGS
MAOMAOS
MOTMOTS
MULMULL
MULMULS
MURMURS
MUUMUUS
NEINEIS
PAWPAWS
PIOPIOS
PIUPIUS
POMPOMS
PREPREG
PURPURA
PURPURE
SARSARS
SEMSEMS
SIKSIKS
TARTARE
TARTARS
TAUTAUG
THETHER
TINTING
TOETOES
TOITOIS
TSETSES
TSKTSKS
TUATUAS
TZETZES
TZITZIS
TZITZIT
WEEWEED
WEEWEES
ZOOZOOS
You're welcome.
looks like it is solved already but since I spent time working on it this is my solution, not as elegant as shg's though...
=IF(LEFT(A1,1)=MID(A1,4,1),A1,IF(MID(A1,2,1)=MID(A1,5,1),A1,IF(MID(A1,3,1)=MID(A1,6,1),A1,"")))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Sambo I will keep that too since that of SHG was beyond professional , I can only understand yours
Passing thought..
=LEFT(A1,3)=MID(A1,4,3)
Omg ...
I was wondering if I can get words where letter 234 equals 567 ,
use below word for testing since I am not sure it will pull any word
out of 40,000 dictionary
ATESTES
Can you not adapt the formula in post #7?
how about =IF(MID(A1,2,3)=MID(A1,5,3),TRUE,FALSE) or something to that effect.
SHG, ha ha, that is all I did.
and don't need the if then part as it will either be true or false anyway.
Last edited by Sam Capricci; 03-29-2017 at 12:48 PM.
Copying Jason's approach try
=MID(A1,2,3)=MID(A1,5,3)
That would also allow longer words like ATESTESXYZ
If you don't want that you could specify the string length too, e.g.
=AND(MID(A1,2,3)=MID(A1,5,3),LEN(A1)=7)
Audere est facere
Thankyou , daddylonglegs , it successfully 24 words
ALFALFA
BAZZAZZ
BINGING
CASEASE
DINGING
ENTENTE
FIERIER
HINGING
KINGING
MINGING
NAYSAYS
PAZZAZZ
PINGING
RINGING
SARSARS
SEMSEMS
SIKSIKS
SINGING
TINGING
TZITZIT
UNSENSE
VERSERS
WINGING
ZINGING
I think I tried to use that one in Scrabble once, I was banned for cheatingOriginally Posted by makinmomb
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks