9.7 Deduplication of simple data

 

There is a data table:

imagepng

Deduplicate the data:

=spl("=?1.id()",A2:A17)

imagepng


https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1655777408703
https://c.scudata.com/article/1655858917319