Hi,

You can use the Data, Filter, Advanced Filter, Unique records only option.
First put one row of titles at the top of each column. Only highlight
columns B:E for this source range and use the Filter in place option. You
can copy the results with column A to a new location.

Cheers,
Shane Devenshire


"jj" wrote:


a b c d e
quantity | size | use |part num |frame
9 65.375 Hd 450-026 A
18 67.3437 Hd 451-CG-004 A
1 67.375 Sill 451T-CG-001 A <
2 67.375 Sill 451T-CG-001 A <
3 67.375 Sill 451T-CG-001 A <
18 70.875 WJambl 451T-CG-001 A
9 67.3437 Horz 451T-CG-002 A
18 67.375 Hd 451T-CG-003 A
9 71.625 SillFp 451T-HP-037 A
18 70.875 WJambl 452-145 A
8 30.6875 Hd 450-026 B
8 32.6562 Hd 451-CG-004 B
4 67.3437 Horz 451-CG-004 B
4 67.375 Sill 451T-CG-001 B
4 21.75 Vert 451T-CG-001 B
8 70.875 WJambl 451T-CG-001 B
4 67.3437 Horz 451T-CG-002 B







I want to eliminate redundancies while summing column "A" and keeping same
comma separated values...
I'm using Excel 2003 and have got real close but I just don't know enuf to
write SUMIF & filter B, C, D, E ARE EQUAL TIL UNIQUE VALUE AND THEN KEEP
GOING?
quantity |size |use |part num |frame
9 65.375 Hd 450-026 A
18 67.3437 Hd 451-CG-004 A
6 67.375 Sill 451T-CG-001 A <--------
18 70.875 WJambl 451T-CG-001 A
9 67.3437 Horz 451T-CG-002 A
18 67.375 Hd 451T-CG-003 A
9 71.625 SillFp 451T-HP-037 A
18 70.875 WJambl 452-145 A
8 30.6875 Hd 450-026 B
8 32.6562 Hd 451-CG-004 B

It is data the CAD program puts out but doesn't do this necessary step.




Thanks in advance,
mike