How to make sure excel value does not repeat itself in a type into activity

Hi there,

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?

Thank you.

Hello there,

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

Hi @Krishna_547,

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.


Hi ,

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