I have list of product names that I would like to extract the last numbers from. I have macro currently that does it for me, but the problem is the user has to enable macros for it to work. I am looking for a formula to take the place of this macro:
Attached is the workbook, thank you!
Please Login or Register to view this content.
Last edited by AliGW; 10-25-2018 at 12:18 PM.
Please try at C2
=AGGREGATE(14,6,--MID(A2,MATCH(1,INDEX(-MID(A2,ROW(INDIRECT("1:50")),1),))-{0,1,2},{1,2,3}),1)
Borrow from blue part from AlKey
Last edited by Bo_Ry; 10-25-2018 at 02:22 PM.
Try this:
Enter in B2 and copy down
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you! Both Formulas achieve the result I am looking for! Sending Rep!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. 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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks