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 |
