I want to Check data exits or not in other columns in one table.
ColumnA ColumnB columnC
1 1 5
2 2 6
3 3 7
4 4 8
I want to Check Column A and Column B ,Column A and Column C,Column B and Column C
if data same,
For example ,I mentioned above.
Column A and Column B are the same data.At that time, I want to add Column names to the List.What Should I do?
- Open excel application scope
- Read range activity to read the data
- For each row loop to iterate through the data
- If condition like
If this equals you can the value assigned to a variable list initialised with default as new list(of string)…initialise this buddy before using a list…thats important
If this condition doesn’t pass in else part use another if condition like
Again the same in then art and leave the else part empty here buddy
Thats all you are done… kindly let know if this works or not buddy
Is that working buddy… @Lwin_Moe_Aung
sorry for late reply.
It is working.
Thank you sir.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.