Removal of lines - Duplicates

[graemekoz]

Good morning

I have a list of data in two columns. As you can see there are two instances of 123456 but the second column has different data.

For example

123456	A
245681	B
123456	D
987654	E

The only thing I'm interested in retaining is the first instance of each number (customer number), so in this case, the 12345 and A would stay but the 123456 and D would be deleted.

Does that make sense? can anyone help?

 

[Skyybot]

Are you interested in a cell Formula solution or VBA solution?

 

[graemekoz]

Are you interested in a cell Formula solution or VBA solution?

More a formula solution i think. I'm not really experience din the VBA

 

[myall_blues]

If you need a formula then please advise what version of Excel you are using. Ideally you should update it in your profile so it displays when you post.

 

[graemekoz]

If you need a formula then please advise what version of Excel you are using. Ideally you should update it in your profile so it displays when you post.

Sorry about that. i didn't even know you could do that. It's 365 and done now.

 

[Fuji]

No vba, formula

1) select the range
2) [Data] - [RemoveDuplicates]

 

[graemekoz]

No vba, formula

1) select the range
2) [Data] - [RemoveDuplicates]

Unfortunately this didn't work. Because the second column doesn't match it doesn't delete anything. What I want it to do is, if the same value appears in the first column, it deletes the duplicate in that column as well as any associated rows .

 

[Fuji]

When RemoveDuplicates dialog comes up, you need to remove tick from column B, so that it removes duplicates in col.A.
Before

Book1
	A	B
1	123456	A
2	245681	B
3	123456	D
4	987654	E
Sheet1

after

Book1
	A	B
1	123456	A
2	245681	B
3	987654	E
4
Sheet1