the data in column a is going to be a part number.
the data in column B is going to be the length of the part.
the data in columns c & d are locations of holes to be drilled into these
parts.

i have already made a fix to look at the lengths of the parts, see which
ones match, and then make both of the parts become the same name. the
problem that im having, is getting the hole locations from both parts
combined to display as one.

does that help ?


"Ken" wrote:

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