Hi Georgyneedshelp

You can insert a formula like this in your data table and filter and delete the cells you want

=IF(COUNTIF($C$1:$C$13,C2)=1,"Unique",IF(COUNTIF($ C$1:$C$13,C2)=0,"Empty","Duplicate("& COUNTIF($C$1:C2,C2)&")"))

Change the range to yours

DataRefiner can do it for you if you want
http://www.rondebruin.nl/datarefiner.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Georgyneedshelp" wrote in message
...
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.