I am trying to make sure that the value I am typing into an ERP does not repeat the same value inside the excel sheet that the robot is fetching the values from. How do I go about this?
The robot is picking all cell values and typing them into an ERP box. I want to set it in a way that if two values exist, then it should type in only a single value and ignore the second.
How do I go about this?
Try using lookup value before writing in to the excel , lookup searches for the input in the table and if the values is not found returns -1 so you can add only if lookup results -1
Thank you for the swift response, I have only a slight idea of your solution. In my case, I am not trying to write into an excel file. I am having the robot read cell values from an excel sheet and writing them into an ERP. So I do not want it to pick a cell content that has the same value.
Let me know if you understand better.
You can try ,
reading the entire column
use remove duplicates , and then loop through each value and type into ERP
Thanks, @Krishna_547. I Will try this out