Distinct Value from a List

Hello,
I don’t know if this question is already asked, but I need to get a column (not the empty or ’ '-valued one, I might add) in an excel, put it in a list variable, and then get a distinct value from it in another list.
For Example:
Element A
Element B
Element A
Element A
Element B
Element C

Then what I need from that list is a new list consists of:
Element A
Element B
Element C

Is it possible to do that?

Thank you in advance.

So you basically need to get rid of duplicate values, right?

You can do it in the Excel file (open it, select the column, press Data - Remove duplicates), and then copy the column to the list.
You can additionally check if there are any empty values after that

Here is a sample recording
duplicates.zip (38.1 KB)

Thank you! @ashapkina This worked too, but I found another method to remove duplicate, as I use Excel function to do this:
First I get each one of a column, then if the value is not on the list (using if ${list} not contains ${value}), then append the value on the list. Like the picture:


I guess there is another more efficient way to do this. If anyone found another method, feel free to tell me!

1 Like