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.

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.

Lubica Zummerova

Thank you Paul! Very helpful, it seems to be working great :)

Paul Newcome

Happy to help! 👍️