Hello.
Thanks for your help.
I have a large data set in which I need to identify the range in Column C based on the repeated values in 2 columns. Once the range is identified, I need to replace the values in the range based on a value in Column D ({CandidateHeader.Email}). For Column C, all User Names will be replaced with the name corresponding to the value {CandidateHeader.Email}.
Sample set below:
Expected result:
The Req ID and Cdd ID won't all necessarily be 5 lines. For {CandidateHeader.Email}, most cases will only have one User name corresponding to it, however if there is a case in which {CandidateHeader.Email} appears twice in a range, it will pick up only the first occurrence.
I appreciate the help.
Thanks.
Regards,
Chris
Thanks for your help.
I have a large data set in which I need to identify the range in Column C based on the repeated values in 2 columns. Once the range is identified, I need to replace the values in the range based on a value in Column D ({CandidateHeader.Email}). For Column C, all User Names will be replaced with the name corresponding to the value {CandidateHeader.Email}.
Sample set below:
Req ID | Cdd ID | User | Correspondence |
12345A | 98765 | User A | |
12345A | 98765 | User B | Random Text |
12345A | 98765 | User C | {CandidateHeader.Email} |
12345A | 98765 | User A | Random Text |
12345A | 98765 | User A | Random Text |
Req ID | Cdd ID | User | Correspondence |
12345A | 98765 | User C | |
12345A | 98765 | User C | Random Text |
12345A | 98765 | User C | {CandidateHeader.Email} |
12345A | 98765 | User C | Random Text |
12345A | 98765 | User C | Random Text |
The Req ID and Cdd ID won't all necessarily be 5 lines. For {CandidateHeader.Email}, most cases will only have one User name corresponding to it, however if there is a case in which {CandidateHeader.Email} appears twice in a range, it will pick up only the first occurrence.
I appreciate the help.
Thanks.
Regards,
Chris