hello
I have data and it's increasble what I want it. it searches data based on cell value J2 . it should match with COL C and bring the data in COL M with considering some items are duplicated based on COL C . it should merge and summing
hello
I have data and it's increasble what I want it. it searches data based on cell value J2 . it should match with COL C and bring the data in COL M with considering some items are duplicated based on COL C . it should merge and summing
Data Range
L M 3 brand food1 4 batch bt-1000 5 type tr 6 import 122 7 export 102 8 balance 20
Data Range
L M 3 brand =INDEX(B:B,MATCH(J2,C:C,0)) 4 batch =J2 5 type =VLOOKUP(J2,C:D,2,0) 6 import =SUMIF(C:C,J2,E:E) 7 export =M6-SUMIF(C:C,J2,F:F) 8 balance =M6-M7
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Vba...
By the way...your export and balance values are swapped around...
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
sintek
thanks for correcting my mistakes .By the way...your export and balance values are swapped around...
yes I prefer by vba . there is no better than vba .
thank you so much
Pleasure...tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks