Finding duplicates and checcking blank cells
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?
Help Article Resources
Check out the Formula Handbook template!