Get only unique values from a column in excel

Hi ,
I have a requirement where I need to get distinct values based on specific column.

Can anyone help me on this

Hi @Robot_1
welcome to community

We can achieve this using linq

first of all use read range and store it in a datatable

next use assign activity and


If you make this false then it will display all the values from the datatable column.

Hope this helps


1 Like

Please provide the data you have and the scenario you are using

Thanks let me try this

Sorry @aquinn data cannot be shared

Sure @Robot_1

Thanks it helped

Happy Automation :slight_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.