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.

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.

It still hasn't worked. Hmmmm... Anymore suggestions?

The row with the duplicate star names is in the E column and the thing that
makes me know whether I want to delete them is in the R column. If there is
writing in the R column and it is a duplicate (i.e. the star has two sets of
data for the same star given in the E column) then I want to delete the
entire row.

Thanks!

"Ron de Bruin" wrote:

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.