Find attached data on a1 , going at 34172 words
Expected results on B and C
Looking for words with same consonants but different vowel combination
It should also be able to pull words with two vowels , 5 same consonants ,
example BANTERS BARNETS BARTONS BRETONS BRISANT BRUNETS BUNTERS BURNETS BURSTEN BURTONS
The macro should also be able to handle 8 letter words , attached is 7 letter word length
Last edited by makinmomb; 10-27-2017 at 03:46 AM.
Based on the wealth of knowledge you have accumulated over time here with many, many, many similar requests, please share the code that you have tried but is not quite working for you. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Please Login or Register to view this content.
This one by Karedog , requirement to get below results with words on a and b , so
what i am asking for is not exactly similar
ALEURON ALEURONE
TRENAIL TREENAIL
RATIONS ORATIONS
STEARIN STEARINE
ESTRONE OESTRONE
INERTIA INERTIAE
GRATINE GRATINEE
OUTRANG OUTRANGE
MINUTIA MINUTIAE
And in what way is it not working? What needs tweaking?
There are hundreds of similar threads, not just that one! Come on, try a bit harder, please!!!!
Aligw thank you for pushing , but can you please stop pushing , my time is allocated into
fighting the bad economic times , so i dont have time at all for this
The definition of a forum is to help , so i am asking for help , simple
They are people around in here don't mind tackling the case
No, actually you are constantly asking for someone else to do it for you. You never show any willingness to try to adapt what you have been shown previously.The definition of a forum is to help , so i am asking for help , simple
Please remember that those who help here do so voluntarily and of their own goodwill. This is not a paid 'service': members will help you to reach solutions, but they do expect a willingness on your part to meet them halfway. If you do not have the time or the inclination to do this, then you really should be posting your requests in the commercial services section, where you can offer recompense to someone for doing what you have no desire to do yourself.
Yes, and you are relying on their goodwill to get your jobs done for you - again and again and again.They are people around in here don't mind tackling the case
Last edited by AliGW; 10-27-2017 at 04:36 AM.
I have come up with an idea that should in achieving what i need
I have got alphgram of the words in this format , assuming
they are on A1 and B1 need formula on C to pull consonants and D pull
vowels , thus would expect NTR AND AEIO for and for ETAERIO i would
expect TR and AEIIO , formula to point on cell b to pull the needful ,
then i will use sort A to Z and use Highlight Duplicate Values using CF
NOTAIRE AEINORT
OTARINE AEINORT
ETAERIO AEEIORT
ANEROID ADEINOR
AILERON AEILNOR
ALERION AEILNOR
AliGW kindly push the thread to Formulas , thank you
Moved as requested.
my time is allocated into fighting the bad economic times , so i don't have time at all for this
... so what is the economic value of your request (and many very similar requests) ??????
I shall say, that I had some time ago similar experience with you makinmomb :-(
It was "do all for me" approach
And not trying to learn, but asking again and again the same or VERY similar question.
Best Regards,
Kaper
HTML Code:
Written by some expert , it sorts me out with the below two
=consonants(B1)
=vowels(B1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks