Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >

Forum Discussion

Walter55

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
MVP
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.