Duplicate Numbers

F

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

Domenic

foolio said:
*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 *
Click to expand...

Hi,

You can use Advanced Filter for this. Select your data, Data > Filte
Advanced Filter, check "Unique records only", and click OK.
Click to expand...

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
 
P

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

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
 
P

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)
 
Top