Dec 28 2022 09:05 AM
Hello,
I have a column1 of data that has some incorrect values. I have the list of incorrect values from column1 in column2 along with the correct value located in column3 and I would like to update the data in column1 with the correct value of column3 if it is found in the list of incorrect values in column 2.
i.e if column1 value is in the list of values located in column2 then replace the value in column 1 with the correct value in column3.
Is there a way I can do this.
Thank You,
Lisa
Dec 28 2022 09:26 AM
SolutionAn alternative could be Power Query. In the attached file you can add data in the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh.
Dec 29 2022 11:01 AM
Dec 28 2022 09:26 AM
SolutionAn alternative could be Power Query. In the attached file you can add data in the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh.