I'm a little confused about the data in column A. There are two 50's
in column B, but one is J1 and one is j4. In the output, they both
appear in a j1 row, and there is no reference at all to the fact that
the numbers on the j1 row arose from data in columns c and d that had
50 in column b.

Ken


On Jul 17, 11:57*am, EBnLP01
wrote:
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