Audra Breedlove
asked on
Values match ID
Hello, I need a formula or macro to help me determine if the values ZPRF, ZCMP and ZGEM appear on a Person's ID
In my file I have employees with duplicate records, which can be identified by Person ID that's missing a grouping reason or a single record that may be missing a Grouping Reason
I need a formula that will look at the person ID and return in Column C "YES", if all 3 grouping reasons exist "NO" if one of the codes is missing and in Column D, the code(s) that's missing
Example
PersonID Grouping Reason All Missing code
10181451 ZCMP YES
10181451 ZGEM,ZPRF YES
10181489 ZCMP No ZPRF
10181489 ZGEM No ZPRF
10181517 ZCMP No ZPRF, ZGEM
zflag-audit.xlsx
In my file I have employees with duplicate records, which can be identified by Person ID that's missing a grouping reason or a single record that may be missing a Grouping Reason
I need a formula that will look at the person ID and return in Column C "YES", if all 3 grouping reasons exist "NO" if one of the codes is missing and in Column D, the code(s) that's missing
Example
PersonID Grouping Reason All Missing code
10181451 ZCMP YES
10181451 ZGEM,ZPRF YES
10181489 ZCMP No ZPRF
10181489 ZGEM No ZPRF
10181517 ZCMP No ZPRF, ZGEM
zflag-audit.xlsx
Is it possible to use macros?
ASKER
Yes
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is going to make my life so easy at work.