Hello,
I'm not sure if this can be done, or with what it can be done with. So, here goes. I have two problems. The first, in column F, I need the letter sequence seperated from the number sequence. Second, in column Q I need to group ranges of numbers with a specific indicator. Can that be done at the same time for the same data set? The workbook provided explains in greater detail. Thank you!
Hi,
One possibility for column F:
First string:
=LEFT(F30,MATCH(TRUE,INDEX(ISNUMBER(--(MID(F30,ROW(INDIRECT("1:100")),1))),,),0)-1)
Second string:
=MID(F30,MATCH(TRUE,INDEX(ISNUMBER(--(MID(F30,ROW(INDIRECT("1:100")),1))),,),0),100)
Regards
Hi XOR LX,
Thank you for your quick response! My column F problem is solved! Thank you! Care to take a stab at my column q problem?
It seems that all your values in Q are negative, but the values you want to group them by are positive? Based on that, create a new table starting at 0 and
Then use this in Q, copied down
=VLOOKUP(ABS(Q30),$E$16:$F$22,2,1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for pointing that out! Error on my part, but, regardless, wonderful job on your part! That works superbly. Thank you both for your help!
Happy to help and thanks for the feedback
Likewise!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks