Hi Everyone - Please help me with below scenario.
I have Data given in sheet “input” where col C has value YES and NO.
I have to update the value of col C as per below requirement:
–> If cell value is YES then update it to “Male”
–> If cell value is NO then update it to “Female”
After upadteing the datatable I have to write it to another sheet “output”.
2nd requirement is:
I have to compare col C from sheet “output” and sheet “actual” and if matches I have write the datatable in sheet “result” with col C as “MATHED” and “NOT MATCHED”.
I have attached the sheet for reference. If possible please share the .xaml file.
Excel column update and comparison.xlsx (10.7 KB)