how it is work duplicate values?

Highlighted
Occasional Visitor

Hi!

I want to know how to work the option "erase duplicates". if i order by ascending date, lastest values are erasing? Thaks!

1 Reply
Highlighted

Hi,

 

Remove Duplicates keeps first met cell among all duplicates, it doesn't matter how they are sorted