I apologize if this has been answered elsewhere, but searching didn't turn it up. My spreadsheet is setup in this manner (only showing columns needed for evaluation):
Date | Name
What I need to do is apply a format to a row only if the value in the Name column is duplicated in the table, and the difference between the Date in these duplicates is less than 30.
Thank you!
Date | Name
What I need to do is apply a format to a row only if the value in the Name column is duplicated in the table, and the difference between the Date in these duplicates is less than 30.
Thank you!