When using the Advanced Filter as shown in the image below, the duplicates will be hidden, not deleted.

$\backslash$table$[[$L$,$A$,$B$,],[1,$Name,Value,$],[2,$Garcia,$2,],[3,$Miller,$2,2],[4,$Lee,$4,],[5,,,],[6,,,],[7,,,],[8,,,],[9,,,],[10,,,],[11,,,],[12,,,],[13,,,]]$

Advanced Filter

Action

Filter the list, in$-$place

Copy to another location

List range:

Criteria range:

Copy to:

Unique records only

True

False