Locating duplicate dates
I have 11 date columns holding each read date for a book.
Some books have actually been read 11 times, but I have about 600 books with 3 or more read dates. I get the dates from Goodreads.
The problem I am facing is that i have a total of 1100 read books and I am having a hard time locating books with duplicate dates read.
Sometimes through accident I might record the same read date twice. It is almost impossible to go through and locate them because I can't scroll down my booklist and focust on the list of DR1, DR2, DR3,DR4, etc. and look for duplicates.
Is there a way of creating a column or an icon that can show up if specific columns have the same dates?
Is there a way of setting a rule that would show if the set dates in specific columns are duplicates? Icon or Color rule? or even a yes/no?
Last edited by Rellwood; 07-23-2023 at 10:52 PM.
|