How does remove duplicates work?

[tonywatsonhelp]

Hi Everyone,
A bit of a different one,
I just want to know how remove duplicates decides which duplicates to remove?

Lets say I have 5 duplicates so rows 1 to 5.
if I remove duplicates does it remove 1 to 4 and leave 5? 2 to 5 and leave 1? or is it random of some other rule?

thanks

Tony

 

[sandy666]

first position of duplicates will stay the rest will be removed

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td]A[/td][td]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]A[/td][td]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]A[/td][td]

3​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]B[/td][td]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]B[/td][td]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]C[/td][td]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]C[/td][td]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]C[/td][td]

3​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]C[/td][td]

4​

[/td][/tr]
[/table]

select range
choose remove duplicates
un-check B column (second)

 

[tonywatsonhelp]

Ok, great thanks for that

 

[sandy666]

You are welcome

Have a nice day