Hi Guys,
Im struggling to find a formula to populate cells based on values to be checked in two fields (ICODE, COMPANY).
In the example shown, all records where ever the ICODE = 49, i need to populate the fields AD1,AD2,AD3 or AD4 based on the same company name and where ever the ICODE <> 49...