Hello Everyone,

Need your superior excel skills. I have a spreadsheet that I need to do the following -

Total how many duplicated part numbers there are.
Deleting the duplicates
Remove the Rev info at the end.

I hope I explained it correctly.

For example:

I need it to go from this:

179049-101 C 15 FIXED OVERHEAD Rev C
179049-101 C 15 FIXED OVERHEAD Rev C
179049-101 C 15 FIXED OVERHEAD Rev C
179049-101 C 15 FIXED OVERHEAD Rev C
179049-101 C 15 FIXED OVERHEAD Rev C
179049-101 C 15 FIXED OVERHEAD Rev C
179458-101 A 15 RETRACT REV A
179458-101 A 15 RETRACT REV A
179458-101 A 15 RETRACT REV A
179458-101 A 15 RETRACT REV A
179458-101 A 15 RETRACT REV A
179458-101 A 15 RETRACT REV A
179458-101 A 15 RETRACT REV A
179458-101 A 15 RETRACT REV A
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B
179469-001 B CA ASSY SEB-DISC, DBL AUDIO Rev B

To this:

179049-101 C 15 FIXED OVERHEAD 6
179458-101 A 15 RETRACT 8
179469-001 B CA ASSY SEB-DISC, DBL AUDIO 11

Thank you in advance.