Hi, i wanted to know whether we can bring Item Batch in Parellal Line to Item Name as shown in Excel Attached Format. 'Present' Sheet contains the default report derived from system. 'Required' Sheet contains the desired result required. I know it seems illogical but some how using advanced excel functions as search, isnumber, if, text, we can crack it out. I am not too sure of success in this just giving it a try for some ultra knowledged excel expert. Thank YOu in advance.
a7=VLOOKUP(MID(B7,7,4)&"*",Present!B$6:B$679,1,0)
Try this in Cell A7 in Required Sheet and copy towards down
see the attached file
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Hi. If this is a one-off; I suggest this way:
To return the drug names in column A (in A6, copy down)
=IF(ISNUMBER(--MID(Present!B6,2,3)),Present!B6,Present!A5)
To return the stock numbers, in B6 and copy down:
=Present!B6
This is 90% of the way htere. Then, in an empty column - I used o6 and copied down
=A7=B7
This will return TRUE where you have the drug name in both columns. Filter the rows with TRUE and delete them. Job done.
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
may i know why and how &"*" worked?
seems quite complicated for novice like me. But thanks a ton for solving it and helping getting me out from miserable manual work.
As a matter of interest, which solution provided you with what you wanted?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks