formula to delete duplicate part numbers

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

Louis

i have a column with over 2000 part numbers. I need a
formula to delete the rows that have duplicate part
numbers, for example:

A B
1589 10.50
1596 11.75
1587 12.25
1589 10.50

i would need a formula that would delete cell A4 because
its a duplicate of cell A1

Thanks
Louis
 
Posted a few days ago:
Select the range, use Data/Filter/Advanced filter
check Unique Records Only and "Copy to another location"
Put in an address to hold the result, eg[F1] then click
OK. When you're done, you will have the unique records in
the new place. You can delete the original range or not.
 
I would select Data - Filter - Advanced Filter from the
menu, and check "Unique records only" at the bottom of the
dialog box. You have the option to filter the list in
place, or to copy the filtered list to another location.
You'd be better off copying to another location so you can
compare the lists and make sure you are correct. You don't
need to select a Criteria range, but you'll need to select
the cell you want to copy the list to. Happy Holidays!
 
-----Original Message-----
Posted a few days ago:
Select the range, use Data/Filter/Advanced filter
check Unique Records Only and "Copy to another location"
Put in an address to hold the result, eg[F1] then click
OK. When you're done, you will have the unique records in
the new place. You can delete the original range or not.

-----Original Message-----
i have a column with over 2000 part numbers. I need a
formula to delete the rows that have duplicate part
numbers, for example:

A B
1589 10.50
1596 11.75
1587 12.25
1589 10.50

i would need a formula that would delete cell A4 because
its a duplicate of cell A1

Thanks
Louis

.
Click to expand...
.
sorry, this is what I really need:
Click to expand...

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 wanted
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.

Thanks
Louis
 
Back
Top