I need to compare two columns in excel and if the value matches, i should skip the matching value and write the un-matching values to new column.
please find the image and requesting your help on this
here i’m comparing the column P and column S , so if the values matches. i should skip the matching number i.e 26 and write 34 and 7 in the column Q
maybe the simple string approach will work
For the Check
row("ESQ-AC Codes").toString.Contains(row("Gasper Action Code").toString.Trim)
row("ESQ-AC Codes").toString.Replace(row("Gasper Action Code").toString.Trim,"")
A multi code handling could look like this
Hey @ppr ,
Thanks for the immediate response and i’m trying with the inputs you have given.
will update once it is successful.
Kindly refer this xaml file,
- For each data table
- Write cell
- Split For Each loop
- Collection List
Forum_ExcelRemoveData.zip (83.7 KB)
Hey @ppr ,
It works, thanks <3
And thanks gokul for the information
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.