Log In
Register
Home
August 25, 2017
Offline
Sunny
I am not sure where to start on this one. I would like to list the next 5 letters in line based on a particular occurrence.
October 5, 2010
Offline
Hi,
Can you supply some example data and the result you expect. As much detail and info as possible 🙂
Thanks
Phil
August 25, 2017
Offline
Sorry, here is the file.
October 5, 2010
Offline
Hi,
Can you provide the context for this, it might make it easier to work out a solution. Why are you trying to do this?
In your examples, you state that you want the letters to the right of the letter in Col Q, but to exclude the letters in Cols R and S.
In your first example the only letters to the right of A, is G, but your expected result is GCBFE.
In the 2nd example, the letters to the right F are EJDG but your expected result is EJDGC.
In the 3rd example there are no letters to the right of G but your expected result is ACDEJ
So I'm not understanding your requirements as the result you state you want does not match up with the expected results you provide.
Regards
Phil
VIP
Trusted Members
June 25, 2016
Offline
Hi Melinda
Perhaps something like this?
What I am doing is :
1) Join the range 2 times using CONCATENATE(). This will allow me to "loop" back to repeat the extraction.
2) Remove the unwanted texts from the concatenated string using SUBSTITUTE()
3) Find the position of the required letter
4) Extract the words from the concatenated string using MID().
Hope this helps
Sunny
1 Guest(s)
