how it is work duplicate values?

Copper Contributor

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

Hi,

 

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