Good Morning,
I would say i am somewhat proficient in Excel. I want to create a report but am clueless of how to put a formula together for what i need so i hope the Excel Lords here can help. Below is a sample of the data set i will be using. What i want to do is have excel look in column A for like data, when it finds it look in column B for the unique data sets that are found and list them along with a sum of column C. Basically this: have excel look at what line its on (Column A), group what families are on that line and the quantity of each family for each line. IE: Line K
Apple-25
Orange-24
Grape-24
Thanks in advance for all your help.
Line Family Order_Num QTY
K_ apple 567849405 10
K_ apple 567848175 15
K_ orange 574545913 24
K_ grape 574546028 24
7L lemon 583482538 1
7L banana 579432711 1
7L banana 587487475 1
7L banana 580694697 1
7L apple 583356435 19
7L apple 585199015 6
H_ grape 587017413 1
J_ apple 585261773 1
J_ orange 585171956 1
G_ grape 584498376 48
I_ lemon 582486415 2
I_ banana 583129675 1
L_ lemon 585685831 1
L_ banana 585685963 1
L_ orange 585686631 1
P_ lemon 584497634 48
P_ banana 584498129 48
P_ orange 584498194 48
J_ lemon 585597788 24
J_ banana 585597762 24
J_ orange 586336376 1
J_ apple 586201166 10
7L apple 579462130 16
7L apple 579697347 1
7L orange 578792172 3
O_ orange 586734257 1
O_ apple 586112025 1
O_ grape 586457560 1
O_ banana 586516696 1
O_ banana 587189162 1
H_ banana 585280864 1
H_ banana 585348125 1
H_ apple 585184462 1
7L apple 587331905 1
J_ apple 579539267 16
J_ grape 579535182 16
J_ grape 579535307 16
J_ orange 579538947 16
7L orange 577965027 1
C_ apple 584005015 20
7L banana 584613578 16
7L banana 586424347 32
Bookmarks