Eliminate duplicates and create a master list PLEASE HELP!!

[ectiger86]

I have two spreadsheets that I have made into one. There are about 4500 rows. I need to eliminate duplicates and create a unique list. Please help!! Deadline is approaching!!

	A	B	C	D	E	F	G	H	I	J	K	L	M
2119	WELLHEAD	BCA	SO10189	C00681	AERA ENERGY LLC	2/4/2014	1/17/2014	2/4/2014	BCA		2,615.25	No	90+
2120	WELLHEAD	BCA	SO17345	C00681	AERA ENERGY LLC	5/1/2014	5/1/2014	5/1/2014	BCA		0.00	No	90+
2121	WELLHEAD	BCA	SO21207	C00920	Kel-Petro Operating, Inc.	5/15/2014	6/25/2014	5/15/2014			9,060.08	No	90+

<tbody>
</tbody>

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	WELLHEAD	BCA	SO21208	C00920	Kel-Petro Operating, Inc.	5/15/2014	8/11/2014	5/15/2014	BCA	CHRISTINA#2	9,060.08	Yes	90+
2	WELLHEAD	BCA	SO26248	C00681	AERA ENERGY LLC	8/26/2014	8/27/2014	8/27/2014	BCA	MARVIC-4101	4,087.00	No	0-30
3	WELLHEAD	CAR	SO19960	C00842	DENALI IRON & DISPOSAL	3/14/2014	7/31/2014	3/14/2014	CAR	RAINWATER # 1-14	805.00	Yes	90+
4	WELLHEAD	CAR	SO21419	C00529	SEECO, Inc	6/24/2014	7/31/2014	6/24/2014	CAR	MCNAIR 9-11 # 3-34H	2,275.00	Yes	61-90

<tbody>
</tbody>

 

[NeonRedSharpie]

There's a button on the ribbon:

Data>Data Tools>Remove Duplicates

 

[caabyyc]

which column is to be used to identify "duplicates"????

 

[ectiger86]

Remove duplicates still leave duplicates. Column c is the unique identifier. Some rows have the same so # in column c but the other data may differ in one other column.

 

[liveinhope]

Remove duplicates still leave duplicates. Column c is the unique identifier. Some rows have the same so # in column c but the other data may differ in one other column.

Remove duplicates DOES work . But you need to specify which columns make a duplicate. The default is that all columns (ie the whole row) must be the same. In your sample 4 rows there are no totally identical rows

eg to remove rows where cols A and B are the same make sure that you only have ticks against those 2 columns before clicking "remove duplicates" . Here is my "after" shot

A

B

C

D

E

F

G

H

I

J

K

L

M

WELLHEAD

BCA

SO21208

C00920

Kel-Petro Operating, Inc.

5/15/2014

8/11/2014

5/15/2014

BCA

CHRISTINA#2

9,060.08

Yes

90+

WELLHEAD

CAR

SO19960

C00842

DENALI IRON & DISPOSAL

3/14/2014

7/31/2014

3/14/2014

CAR

RAINWATER # 1-14

805

Yes

90+

<colgroup><col width="80" style="width: 60pt; mso-width-source: userset; mso-width-alt: 2925;"> <col width="34" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1243;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="56" style="width: 42pt; mso-width-source: userset; mso-width-alt: 2048;"> <col width="189" style="width: 142pt; mso-width-source: userset; mso-width-alt: 6912;"> <col width="75" style="width: 56pt; mso-width-source: userset; mso-width-alt: 2742;" span="3"> <col width="34" style="width: 26pt; mso-width-source: userset; mso-width-alt: 1243;"> <col width="159" style="width: 119pt; mso-width-source: userset; mso-width-alt: 5814;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="32" style="width: 24pt; mso-width-source: userset; mso-width-alt: 1170;"> <col width="44" style="width: 33pt; mso-width-source: userset; mso-width-alt: 1609;"> <tbody> </tbody>