Say I have the word AIRDATES that needs to be looked into the word SATIRE
and then pull the answer which is AD
I have down the 4 manually in the attached file
Please Login or Register to view this content.
Say I have the word AIRDATES that needs to be looked into the word SATIRE
and then pull the answer which is AD
I have down the 4 manually in the attached file
Please Login or Register to view this content.
Logically you are telling the formula to Minus Text AIRDATES Minus SATIRE
Formula on A1 for dragging downwards
Hi,
You'll have to explain exactly what you're wanting. I'm not clear which is your data and which your results and how you move from one to the other. Describe your thought process that enables you to arrive at the results referring to specific cells and any rules you are applying.
Am I correct in thinking that you are also processing anagrams , i.e. SATIRE is a partial anagram of AIRDATES
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Hi there. Try this out.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
A1=substitute(substitute(substitute(substitute(substitute(substitute(substitute(substitute(substitute(substitute($b1,mid($f$1,1,1),"",1),mid($f$1,2,1),"",1),mid($f$1,3,1),"",1),mid($f$1,4,1),"",1),mid($f$1,5,1),"",1),mid($f$1,6,1),"",1),mid($f$1,7,1),"",1),mid($f$1,8,1),"",1),mid($f$1,9,1),"",1),mid($f$1,10,1),"",1)
try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
One way:
Please Login or Register to view this content.
Row\Col A B C D 1DA AIRDATES SATIRE A1: =MM(B1, C$1) 2DA DATARIES 3DA RADIATES 4HA HETAIRAS
Entia non sunt multiplicanda sine necessitate
Hi. Try this out...
GLENN your answer is correct but needs to go onto A1 , not sure if it can write as AD instead of DA
Richard is the STEM ( SATIRE ) minus the actual word ( AIRDATE ) = AD , i hope this is now clear
SHG i admires your too , if you could send it as a file please
Row\Col A B C D 1AD AIRDATES SATIRE A1: =MM(B1, C$1) 2AD DATARIES 3AD RADIATES 4AH HETAIRAS
Please Login or Register to view this content.
I have taken SHG solution , while leaving the thread open in case someone finds a way through formula
I think it will be difficult to swap by alpha formula wise
In response to your PM:
Copy the code from the post
In Excel, do Alt+F11 to open the VBE
Insert > Module
Paste in the window that opens
Do Alt+Q to return to Excel.
Thanks SHG got it correct , I re did it
You're welcome.
It can be done by formula... but. Stick with SHG's solution.
wow non vba , admire the length of the formula , thanks glenn ,
I will keep this too along with SHG file already started using
Last edited by makinmomb; 01-04-2015 at 04:44 AM.
If I wrap the formula its not even visible , thus i used a notepad ,
this is how long it is and does the work just as the macro of shj
Please Login or Register to view this content.
Last edited by makinmomb; 01-04-2015 at 04:54 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks