Deduplication of data

[garymu16]

Can anyone suggest how I could quickly deduplicate a range of data where column A is a project code & column B is a value?

What I would like to do is remove all instances whereby the project code appears more than once (over 15k lines). The value in column B will remain constant thru' the project code.

Many thx in advance all!

 

[Peter_SSs]

garymu16

If a project code appears in column A several times, are they all together in a group of rows or scattered down column A?
And just confirm whether you want to keep one instance of that project code or delete them all?

 

[garymu16]

Hi Peter,

The project codes would be scattered down column A. There may be one instance there may be multiple instances.

Also, I would like to keep one instance visible.

Many thx

Gary

 

[Peter_SSs]

Gary

See if this is any use.

1. In C2 (copied down): =COUNTIF(A$2:A2,A2)
2. Select column C by clicking its column heading.
3. Data|Filter|AutoFilter
4. Click the AutoFilter drop-down in C1 and choose (Custom)
5. In the top left box choose 'Is greater than' and in the top right box choose 1|OK
6. Select the remaining visible rows (the duplicates) and Edit|Delete Row|OK
7. Data|Filter|AutoFilter to remove the AutoFilter and display the unique list.
8. Delete column C

Here it is after step 1

Mr Excel.xls
	A	B	C	D
1	Project Code	Value	Dup
2	ABC	44	1
3	DEF	7	1
4	GHI	9	1
5	ABC	44	2
6	ABC	44	3
7	JKL	2	1
8	DEF	7	2
9
Delete Duplicates

 

[garymu16]

You, my friend...............are a saviour!!!