see the attachment i want to extract Quantity like that 5.290, 1.83,2.23 this Quantity appear after word QTY or some time WT. or
some time WEIGHT or some time more different , so be careful for that , and also see Before After sheets for what i expect
May be like this
G8=IFERROR(LOOKUP(99^9,MID(E8,IFERROR(SEARCH("QTY.",E8)+4,SEARCH("QTY",E8)+3),{1,2,3,4,5,6,7,8,9,10})+0),"")
Try this, copy and paste towards down
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Your formula did not work in specific condition see the atttachment i highlighted that area where your formula is not working
Hi keshavtale,
Try this formula:
Enter in G8 and copy down
Formula:
Please Login or Register to view this content.
Last edited by AlKey; 04-06-2019 at 01:23 PM.
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
Please try at G8
=IFERROR(--MID(E8,-LOOKUP(0,-FIND({"QTY","WT","ITY","="},E8)-{4,3,3,1}),5),"")
Thanks for solution, now my problem is solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks