need to know how to delete duplicate rows

  • Thread starter Thread starter Louis
  • Start date Start date
L

Louis

This is what I'm looking at:

A B C
5 8143 UNIT BRAKE TEMP MONITORING UNIT 351H51002
124832 5273 VOLT METER 124832
124834 6771 AMMETER METER 124834
124835 5272 FREQUENCY METER 124835
124838 34 CSD TEMP INDICATOR 124838
124838 44 IND, CSD OIL TEMP 124838
124838 217 IND, CSD OIL TEMP 124838
124838 4306 CSD TEMP IND 124838
1652 3918 VALVE PRESS RELIEF 1652

I need the description in column C. BUT I only need 1
description per part number(column A). So if i delete the
duplicate part numbers in column A, then I would be left
with only 1 description in column C, lining up w/ the
remaining part number in column A. So thats why I want
to delete the duplicate part numbers (rows) in column A
and that would leave me with the description in column C.
Pay no attention to column B.

Please help.
Louis
 
1. Insert this into D1 and copy all the way down.
=IF(COUNTIF($A$1:A1,A1)>1,1,"e")
2. Select column D.
3. Press F5 > Special
4. Click Formula and uncheck everything underneath except
Number.
5. Press <Ctrl><->.
6. Select Entire row and press OK.

HTH
Jason
Atlanta, GA
 
Back
Top