deleting duplicate rows

Copper Contributor

I have a list of books read which has duplicate rows in every other row. I'd like to delete the duplicate rows. So far, I'm not having any success. I could use some help, please

2 Replies

@Walter55 

=IF(COUNTIF($A$2:A2,A2)=1,A2,"")

With this formula you can select each book title once. Then you can copy the result range which is B2:B19 in this example and paste only values. Then you can delete range A2:A19.

book titles.JPG 

@Walter55 

If you are on 365 you may use UNIQUE() function