I am having two excel files in which one has data in form of true and false and another in form of 0 and 1.
Here “0” means False and “1” means True.
So i need to convert the values from 0 to False and 1 to True in the data table.
Here is the screenshot of data table for conversion
and then to match the values in both data table and then to find the unmatched rows in a new excel.
I am attaching the excel file here
Convert.xlsx (181.8 KB)
This excel contains Sheet1, Sheet2 and Output required sheet.