Duplicate Data

sj1601

Board Regular
Joined
Aug 12, 2006
Messages
96
Hi All,

I have two rows of data. In one row there is data duplication (meaning I have say "John Smith" twice). I want to set up a formula to get rid of the duplicates and the data to appear only once.

Any suggestions?

Thanks.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi,

your post has some confusing elements
1. "two rows of data", but you are talking about only one with duplicates
2. do you really want a formula, ot do you just want to delete the duplicates ?

if your data would be displayed in columns you could use "advanced filter" to get rid of the duplicates

so please clarify a bit and provide a little example

TIP: there are a lot of posts about duplicates
did you "search" ? (see top of the page)

kind regards,
Erik
 

sj1601

Board Regular
Joined
Aug 12, 2006
Messages
96
Thanks Erik for the response.

I figured a way out. Your solution helped too.

Thanks.
 

Forum statistics

Threads
1,136,368
Messages
5,675,358
Members
419,565
Latest member
Phil57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top