Forum Discussion

Copper Contributor

Feb 16, 2023

deleting duplicate rows

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

excel

Formulas and Functions

2 Replies

SergeiBaklan
Diamond Contributor
Feb 16, 2023
Walter55

If you are on 365 you may use UNIQUE() function
OliverScheurich
Gold Contributor
Feb 16, 2023
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.