Formula to remove duplicated datas.

[asyamonique]

[TABLE="width: 188"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]DUPLICATES[/TD]
[TD]RESULT[/TD]
[/TR]
[TR]
[TD]100001123[/TD]
[TD]100001123[/TD]
[/TR]
[TR]
[TD]100001123[/TD]
[TD]100001124[/TD]
[/TR]
[TR]
[TD]100001123[/TD]
[TD]100001125[/TD]
[/TR]
[TR]
[TD]100001125[/TD]
[TD]100001126[/TD]
[/TR]
[TR]
[TD]100001123[/TD]
[TD]100001127[/TD]
[/TR]
[TR]
[TD]100001127[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001125[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001124[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001124[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001124[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001124[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001126[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001125[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001125[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001127[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001127[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]100001127[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Good Day,
What is the formula I can put to put fresh data with no duplicates.
Many thanks.

 

[SteveO59L]

you could use an advanced filter, or a pivot table

 

[JazzSP8]

Or, if it's literally just a bunch of data you need to remove duplicates then you can highlight the data, select the 'Data' tab and then 'Remove Duplicates' and follow the instructions from there.

 

[asyamonique]

Hi,
Thanks for the clue but I do that way buy exporting the datas from different workbook copy entire data onto original file by macro.The worksheet has more details to add that's why I'm just looking for the formula which I can place on the column starting from J2 and all the way down.Source data placed from B8 all the way down.
Many Thanks