difference

[ntudev]

Hello

Can someone help me figure out how to make the Extra column work in this case. I just want a formula that will find the same PAC number but different KeyNumber and if there is an extra acceptancecode in one of the KeyNUmbers then say Yes else No. I bolded what i'm trying to do below.

No	PAC	KeyNumber	AcceptanceCode	Extra
1	99728997	105-0001096291	99978	No
2	99728997	105-0001096291	654987	No
3	99728997	105-0001096368	99978	No
4	99728997	105-0001096368	258369	Yes
5	99728997	105-0001096368	654987	No
6	85728997	112-0001096291	99777	No
7	85728997	112-0001096291	321654	No
8	85728997	112-0001096368	99777	No
9	85728997	113-0001096368	582137	Yes
10	85728997	113-0001096368	321654	No

[cjaneczko]

Try this.

[MilindG]

@ntudev See if the attached workflow works for you.