Checking for Duplicates in Parent Row ONLY

victoriadu

Hi,

I am trying to build an equation/IF statement that Flags projects with duplicate project numbers. I only want the equation to apply to the Parent project number (because the children under the project have the same project number and would trigger the check box). This is what I was thinking but doesn't seem to work for my purposes.

=IF(AND(Parent@row=0,(COUNTIF([Unique ID]1:[Unique ID]1032,[Unique ID]@row)>1;1)

Any help you could provide would be much appreciated! Thank you in advance

Paul Newcome

You would use a COUNTIFS instead and include a range/criteria set of the Parent Column being equal to zero.

victoriadu

Thank you for the quick response @Paul Newcome ! For some reason I am still getting #UNPARSEABLE when using the COUNTIFS Function... any thoughts as to why?

=COUNTIFS(Parent1:Parent1080, =0, [Unique ID]1:[Unique ID]1080, [Unique ID]@row)>1;1)

Paul Newcome

The semi-colon should be a comma. Sorry for missing that the first time.