Clean duplicates but keep the rows

[Gabriell]

Hello Everybody,

I'd like to clean the duplicates from a column and to keep only 1 entry, but I'd like to keep the 1st record and all other data from the other rows.
How Can I do that?
I'm using Office 365.

Thanks,
Gabor

 

[RedNectar]

Hi @Gabriell ,

If you enter

=IF(C7<>C6,C7,"")

in cell H7, then fill down from H7 to H14 I think you'll achieve what you want

Book4
	A	B	C	D	E	F	G	H	I
1
2
3
4
5
6	Data	Other	Code			Data	Other	Code
7	Robert	Q1	AAA			Robert	Q1	AAA	=IF(C7<>C6,C7,"")
8	Robert	Q2	AAA			Robert	Q2
9	Robert	Q3	AAA			Robert	Q3
10	Robert	Q4	AAA			Robert	Q4
11	Anna	Q1	BBB			Anna	Q1	BBB
12	Anna	Q2	BBB			Anna	Q2
13	Anna	Q3	BBB			Anna	Q3
14	Anna	Q4	BBB			Anna	Q4
Sheet1

Cell Formulas
Range	Formula
F7:G14	F7	=A7
H7:H14	H7	=IF(C7<>C6,C7,"")

 

[Gabriell]

Hi @RedNectar ,

Thank you for your reply. While the provided solution works for sorted data, is there a way to clean duplicates from unsorted columns as well?

PS. Your reply helped me to solve my issue. so thanks!
Gabor

 

[alansidman]

Show example of unsorted data and how you would like the result to look. Please use XL2BB so we don't have to retype your data to get a workable solution.

 

[Gabriell]

Show example of unsorted data and how you would like the result to look. Please use XL2BB so we don't have to retype your data to get a workable solution.

Hi @alansidman,

I couldn't install the XL2BB, but I paste the date here, I hope you can use it easier.
The request is to find the first match in the "Code" column for each "Name" and remove any duplicate entries. For instance, Robert should only have one instance of the code "AAA," Anna should have one instance of the code "BBB," and Alex should have one instance of the code "CCC."

ORIGINAL				RESULT
Name	Other	Code		Name	Other	Code
Robert	Q1	AAA		Robert	Q1	AAA
Robert	Q2	AAA		Robert	Q2
Robert	Q3	AAA		Robert	Q3
Alex	Q4	CCC		Alex	Q4	CCC
Anna	Q1	BBB		Anna	Q1	BBB
Anna	Q2	BBB		Anna	Q2
Anna	Q3	BBB		Anna	Q3
Anna	Q4	BBB		Anna	Q4
Robert	Q5	AAA		Robert	Q5
Robert	Q6	AAA		Robert	Q6
Alex	Q7	CCC		Robert	Q7
Alex	Q8	CCC		Robert	Q8
Robert	Q9	AAA		Robert	Q9
Anna	Q5	BBB		Anna	Q5
Anna	Q6	BBB		Anna	Q6