Hello,

Thanks for all the help.

Adding a new helper column next to my incident number column with a countif statement is exactly what I needed. I can just filter for anything with a count >1, then manually filter for blank date closed fields (I'm sure I could have built this into the formula as you said, but it is so quick to do it manually I just skipped that part), and remove them manually.

I just needed a creative way to identify duplicate values without using the remove duplicates or highlight duplicates. I am not sure why the excel coding allows the countif statement to filter in a reasonable amount of time compared to conditional formatting, but I don't really care because you helped fix my issue!

I know no one here is paid to monitor forums and help answer excel forums, so I really appreciate anyone who took time to read and/or reply to my thread!