Sir,
In excel sheet1 having stock verified before list and excel sheet2 having stock verified after, i want to know the balance quantity in excel sheet2 H143 cell to H1076 cells, the some of order given medicines rows are not same line.
Sir,
In excel sheet1 having stock verified before list and excel sheet2 having stock verified after, i want to know the balance quantity in excel sheet2 H143 cell to H1076 cells, the some of order given medicines rows are not same line.
are we matching the following headings
Sl. Item Code Batch No
No.
if so we should be able to use a SUMIFS()
does this work
=F5-SUMIFS('BEFORE STOCK'!$E$5:$E$1078,'BEFORE STOCK'!$A$5:$A$1078,'STOCK VERIFIED'!A5,'BEFORE STOCK'!$B$5:$B$1078,'STOCK VERIFIED'!C5,'BEFORE STOCK'!$D$5:$D$1078,'STOCK VERIFIED'!E5)
See column I
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Sir, I am matching Item Code Item Name Batch No only not serial number. because SI.NO may change some medicine orders, so please give correct one..
ok,
just these three
Item Code - column b , lookup c
Item Name - column c , lookup d
Batch No - column d , lookup e
you just need to change the ranges and the lookup value , as below
do you follow how sumifs - works at all
then you should be able to apply or change yourself depending on any changes to the requirement
happy to have done it for you, just thinking how you may know what to change in future or appy
=F5-SUMIFS('BEFORE STOCK'!$E$5:$E$1078,'BEFORE STOCK'!$B$5:$B$1078,'STOCK VERIFIED'!C5,'BEFORE STOCK'!$D$5:$D$1078,'STOCK VERIFIED'!E5,'BEFORE STOCK'!$C$5:$C$1078,'STOCK VERIFIED'!D5)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks