I am looking at stars. All the stars are named and I am trying to delete the
ones that duplicated.

Star Name Other Star Name
1 F1
1
2
3 F3
3

It looks a bit like that.

Anyway, need to delete the ones with F1 and F3 in them as they are not as
accurate. Tried using that cpearson code but it deletes the wrong row. Tried
using an IF function - =IF(A20,0,1) and then sorting again so that it sorts
it by Star name and then descending order 1 then 0. Then tried copying this
and pasting special with values only and sorting again. None of these worked.
Please help!

Thanks.