deleting duplicate rows

Occasional Visitor

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



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 


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