Suggested test data to answer this post: http://www.excelfox.com/forum/showth...0754#post10754

Using Excel 2007 32 bit
Row\Col
A
B
C
D
E
F
G
1
 Customer: Assembly #: Assembly Name:
2
 # Qty Per Ref/Designator Description Customer PN Internal PN Manufacture PN
3
1
1
Nu Torque
13456
456
456
4
2
1
Blu Origin
Spaceship
457
457
5
3
2
Jet Blue21
ABC
458
458
6
4
3
EXCELL123
123
ABC
ABC
7
5
3
Toyota
Supra
460
460
8
6
2
Emirate
ABC12345
461
461
9
7
1
Angel
ABC12346
462
462
Worksheet: Original


Using Excel 2007 32 bit
Row\Col
A
B
C
D
E
F
G
1
 Customer: Assembly #: Assembly Name:
2
 # Qty Per Ref/Designator Description Customer PN Internal PN Manufacture PN
3
1
1
Nu Torque
13456
456
456
4
2
1
Blu Origin
Spaceship
457
457
5
3
2
Jet Blue23
ABC
DEF
DEF
6
4
3
EXCELL123
123
ABC
ABC
7
5
3
Toyota
Supra
460
460
8
6
2
Emirate
ABC12345
461
461
9
3
2
Jet Blue21
ABC
458
458
Worksheet: NEW