Peter_BrowningCopper ContributorNov 24, 2023Help with Formula I have a set of data like this: Reference Code Type 12502 FR19511107 Salary 12502 FR19511101 NI Conts 12502 FR19511161 Call Out 12502 ...Show More
HansVogelaarMVPNov 24, 2023Peter_Browning In D2: =IF(OR(RIGHT(B2,4)="1101",C2="salary"),"FR19511107",B2) Fill down.
