Finding duplicates and checcking blank cells

Lubica Zummerova

Hi there,

I am at my wits end and I think it is a very easy solution, however I cant see it.

I have a column of project numbers, and I am trying to see if there are any duplicates, as well as if the project number cell is black, to leave it blank. What I have done is sort the project number column in ascending order and in another column I did e.g: =IF([Project Number]17 = [Project Number]18, "Duplicate"). This works fine, however I would also like to add a condition to check if the project number cell is blank. I have tried the formula in the picture, but the result is unparseable. Am I formatting he two conditions in a wrong way or what could the problem be?

Could you please help?

Thank you!

Paul Newcome

Try something like this...

=IF(AND([Project Number]@row <> "", COUNTIFS([Project Number]:[Project Number], [Project Number]@row) > 1), "Duplicate")

This will allow you to sort the rows in any order and it will still check for duplicates.