Formula to remove duplicated datas.

[asyamonique]

DUPLICATES	RESULT
100001123	100001123
100001123	100001124
100001123	100001125
100001125	100001126
100001123	100001127
100001127
100001125
100001124
100001124
100001124
100001124
100001126
100001125
100001125
100001127
100001127
100001127

<colgroup><col><col></colgroup><tbody>
</tbody>

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