If someone could help me with this problem in excel, then the lottery would be solved!
Look at the below example as this is as simple as I can explain it! Please don’t over think this problem or you will get stuck like me!
Take the three words for example, Cake, Lace, Tape:
In the above three words, the common string letters in each word is “ae”
I am trying to develop a macro that can look at per say these three words for simplicity and find the common string letters amongst the words and tell me how many times the common strings appeared in a list of words- in the above example, the macro would tell me strings “ae” appeared in three words.
Look at the following words for a more complex, yet another simple example. Don’t limit yourselves to traditional words:
Abxdfg
Ltrad
Dad
Ltm
As you can see the macro would tell me string “ad” is the common strings and it appeared in three words. The macro would have told me also that string “lt” appeared was a common string and it appeared in 2 words, but the reason why it wouldn’t tell this information is because I had specified only find a 2 letter length common string that appeared in at least 3 words or more.
I can easily right a macro with this subroutine logic for 6,000 words with 5 or less letter lengths long.. but keep reading..
I know this sounds easy but what if the word length is 100 letters long? This is my dilemma! Lets say I need the macro to find me a 20 string length of common letters among 6,000 words, which are each 100 letter length. This is where it gets challenging because each letter in a 100 length word can be chosen from A-Z. When I run the macro, according to my calculations it will take centuries to scan 6000(100 letter length words) and find a 25 common string amongst the words. Any thoughts?
Maybe it's the control logic that I wrote in the macro to decipher each word, which causes the lengthy cross examinamination. I have a quad core processor desktop and it's still taking the calculations a long time to do. Excel tells me it will take 800 years to complete the examinations
it's like technology haven't caught up with expressions I would like a program to do.. Maybe I lack enginuity, but nevertheless, maybe you guys can pitch in