View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
EBnLP01 EBnLP01 is offline
external usenet poster
 
Posts: 8
Default Getting the out put from different cells

You guys have helped me out alot, now here's another one for yall !!

a b c d
1 j1 50 12 30
2 j2 42 15 0
3 j3 46 14 0
4 j4 50 17 0


the output that im looking for would be this :

j1 quantity 2 12,17,30
j2 quantity 1 15
j3 quantity 1 14

basically, i want to :
1) find all the same numbers in column in column b
2) add the quantity of exact matches together
3) and then display the assoisacted numbers from columns c and d (no math to
these numbers...they must stay the same...see above)

Can this be done ?

Thanks for everything !!

EBnLP01