Multi-Field Formula Help

[rrafferty2]

How do I flag/remove the first duplicate Unit code with a formula.

Right now, I am only flaging the first unit code with a duplicate.

I have three conditions with one of the conditions being a possible duplicate unit code number in the dataset.

I can provide screen shot or sample if needed

Thanks

Robb

isempty ([Tier Association]) and [Subconsol Name] = [Subcon Name Mix] and [Unit Code] = "0004"

//any and all duplicate unit code with 0004 as example

[AbhilashR]

Hi @rrafferty2 , it would be beneficial if you could provide us a sample of how your data is currently structured, and what should the final output look like.

[fmvizcaino · Accepted solution]

Hi @rrafferty2 ,

One idea is for you to bring the count of occurrences to your main dataset and use it as your condition (occurrences >1)

Example attached.

Best,

Fernando Vizcaino

[rrafferty2]

[fmvizcaino · Accepted solution]

Hi @rrafferty2 ,

Example attached. I've created a flag that shows the first duplicated unit code that are exactly below.