Hello guys,
I realy did my best. I have 2 columns and I want to extract from them a list of unique products however there are products which has the same name but with different code recorded in the same row in the next column. Then I must calculate the gross and net total, but again I can not insert the condition of identical names and different code? if someone will help I will be grateful to my death.
Hi and welcome!
You made calculations for unique product name. If you need two or more criteria like Product name and Product code - use Sumifs().
=SUMIFS(SumRange;CriteriaRange1;Criteria1;CriteriaRange2;Criteria2)
First of all you could copy all products and codes in one table and then use Remove Duplicates from Data ribbon. This will give you list of unique products & codes.
Then use Sumifs() formula with criterias Product name and Product code.
thank you very much for your help, half of the task is done. but I am wondering if there any formula to use instead of remove duplicates since my boss want the data in two columns insted of one. Btw I found here in the forum the formula for extracting unique values that I used, but I dont know how to make it for one more criteria - code to match.
I want to write some formula in B23 and/or C23, so in future To write only the common data and excel by hisself to make the calculations.
Last edited by marinelkata; 12-26-2016 at 01:15 AM.
okay try with a helper column
N23with control+shift+enter and drag down!!!Formula:
Please Login or Register to view this content.
now
B23=TRIM(MID(SUBSTITUTE($N23,"/",REPT(" ",50)),(COLUMNS($B$23:B23)-1)*50+1,50)) and drag towards column B23:C36
May be that should help.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
I don't know how to say how much i thank you. The both of you. You made my life much more easier. Thanks again to kasan and specially to Ankur Shukla!
This forum is awesome place.
Glad to help you, If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED & Please add reputation by clicking star * icon left corner post on your screen. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks