Need a run button at where i have bordered
Display results against CRITERIA BOX yellow and orange , see expected results
Macro to search data at 5o,ooo rows dictionary which i will paste at those columns
File attached
Need a run button at where i have bordered
Display results against CRITERIA BOX yellow and orange , see expected results
Macro to search data at 5o,ooo rows dictionary which i will paste at those columns
File attached
Last edited by makinmomb; 02-21-2022 at 02:14 AM. Reason: I will
Macro code
Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Please Login or Register to view this content.
Last edited by jindon; 02-21-2022 at 03:56 AM.
KV , u r almost there , it needs to run for SEVEN letters words and then EIGHT , you will be able to tune that i am sure
Also it should I allow to search one hook kind if i leave one of the boxes blank
Re attach sample
I have corrected the code:
Please Login or Register to view this content.
It does not do the work as it pours this for D , it not pulls for the SEVENS of the same , then it not pulls if I put H on front , expected it should have pulled OARIEST
ORDINATE ds 3
NOTARISE ds 12
INSOLATE ds 32
OUTRAISE ds 35
RESINATE ds 44
IODINATE ds 48
Your expected result is the same as macro result.
Explain fully what do you mean by front and back and how selection is to be done.
column C are hooks back for 7 letter words
column H are hooks back for 8 letter words
column b are hooks front for 7 letter words
column g are hooks front for 8 letter words
It should pour results twice ( 7 letter words ) the ( 8 letter words ) vice versa provided it keeps a row to separate them
Foer any other letters give result. What do you mean by hook.
For L on L2 it should pick the below and nothing else since there are no EIGHTS with end L
SOREDIA L 50
Try this
Please Login or Register to view this content.
Added more words , expected results of BACK S , find attached
The result is from column A. What about the list in column F.
Please Login or Register to view this content.
Jindon thank you for closing the thread with plugging T at FRONT it pours these
AILERON T S 5
ACONITE T S 94
AILERONS T 28
What's wrong?
Have you seen post #14
I had created some code for this but decided not to share as it is somewhat crude, my code also pulled the above in as results for front, the code below is longer than it should be but will share as it may help?
To be honest the code above is pretty similar to kvsrinivasamurthy's but longerPlease Login or Register to view this content.
Hope this helps
Its working as required I meant, i have pasted my long dictionaries too
I am cramming all the words of interest these are PLAYable if you put a Y infront
EARLIES py t 266
EARDING by 327
EASTING bfry s 354
AWNIEST flty 921
EARNING dly s 1467
EARNERS ly 2501
EANLING wy s 3112
OURSELF y 8556
BOUNDEN y 14053
AWNINGS dfy 18730
ATAGHAN y s 24228
CLEEPED y 25311
EARNINGS ly 2129
EANLINGS wy 4161
RAVISHED y 7464
CLEEPING y 16673
SHENDING y 18857
ATAGHANS y 28781
A big thank you again to Jindon
Thank you to others , kv would have got it prior if he understood what i meant by front hook
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks