Ben McClave wrote :

Hello,

Here is a different approach that also seems to work. This macro copies all
data to a new sheet, sorts by Rank, removes duplicates based on Name and
Risk, then sorts by name.

I used the very same technique, with the only difference of using the
same (TargetRange) range in the originally sheet.

But there should be a more elegant way of FINDing with multiple WHAT:=
May be with SQL query???

Bruno