Hi,
I am not aware of a way how to remove duplicates directly with IBM RPA actions (maybe some complicated loop), however, you can run an Office Macro.
![](https://dw1.s81c.com//IMWUC/MessageImages/bb5ec90e1c8547229a8c22adf2d07f2a.png)
Dim ws As Worksheet
Set ws = ActiveSheet
' Define the range where duplicates need to be removed
Dim rng As Range
Set rng = ws.Range("A1:A" & ws.Cells(ws.Rows.Count, "A").End(xlUp).Row)
' Remove duplicates in the defined range
rng.RemoveDuplicates Columns:=1, Header:=xlYes ' Change Header to xlNo if there is no header row
Example of macro(s) is also here: https://stackoverflow.com/questions/61182776/how-do-i-delete-duplicated-rows-in-vba
------------------------------
Milan Babčanec
------------------------------
Original Message:
Sent: Tue May 28, 2024 12:18 PM
From: Alex Virrueta
Subject: Get duplicate values from an Excel column
Hi,
How can I get duplicate values from a column Excel, for Example, the column looks like this:
![](https://dw1.s81c.com//IMWUC/MessageImages/e14d81349520417e8af42c476f5a8cbe.png)
I just need this![](https://dw1.s81c.com//IMWUC/MessageImages/600703d86e0d459a80011ccd536bacde.png)
Thanks for your help
------------------------------
Alex Virrueta
------------------------------