Duplicate Numbers

[foolio]

I have a row with part numbers and a row with prices.
I would like to delete all the rows that are duplicates in BOTH par
number and price, while leaving duplicate part numbers with differen
prices for me to look at a little bit closer.

Example:
110234 -- $1.7
110234 -- $1.7
110235 -- $2.1
110235 -- $2.1
110235 -- $2.3
110236 -- $6.1
110236 -- $6.1

Turns into:

110234 -- $1.7
110235 -- $2.1
110235 -- $2.3
110236 -- $6.

 

[Domenic]

*I have a row with part numbers and a row with prices.
I would like to delete all the rows that are duplicates in BOTH par
number and price, while leaving duplicate part numbers with differen
prices for me to look at a little bit closer.

Example:
110234 -- $1.7
110234 -- $1.7
110235 -- $2.1
110235 -- $2.1
110235 -- $2.3
110236 -- $6.1
110236 -- $6.1

Turns into:

110234 -- $1.7
110235 -- $2.1
110235 -- $2.3
110236 -- $6.1 *

Hi,

You can use Advanced Filter for this. Select your data, Data > Filte

Advanced Filter, check "Unique records only", and click OK.

If you want to have the filtered list copied to another location, the
check "Copy to another location" and enter the location in the "Cop
to" box.

Hope this helps

 

[pikapika13]

Your question was how to delete ALL duplicate rows.
Your example actually shows one of the duplicates of the serial number


This method should be display all the unique data from your sprea
sheet:

Column C: =Concatenate(A1,B1)
copy down

Column D: =IF(COUNTIF($C$1:$C$500,C1)=1,A1&" - "&TEXT($B1,"$0.00"),"")
copy down...


I hope this is what you were looking for..

 

[AlfD]

Hi Pikapika13

Doesn't this only pick the item if there is precisely 1 of it? So i
there are 3, none is selected?

On a more positive note, I'm with Domenic.

Al

 

[pikapika13]

yes...according to his original request...he wanted all duplicate row
deleted.
If he wanted the the ones that show up multiple times, I would suggest
AutoFilter, Pivot Table, or a different formula (with column A sorted)