Feb 16 2023 06:16 AM
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
Feb 16 2023 06:42 AM
=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.
Feb 16 2023 08:26 AM
If you are on 365 you may use UNIQUE() function