Deleting multiple rows

[Govind_Dileep_G]

Hi,

I am trying to delete all other duplicates if a particular value is same in the previous row and the next row. can we do that? if anyone has any idea. Please do share

[patrick_mcauliffe]

Take a look at the Unique tool.

Its in the Blue (Preparation) set.

[messi007]

@Govind_Dileep_G,

You can use a unique tool on the preparation pane.

Hope this helps!

Regards

[Emil_Kos]

Hi @Govind_Dileep_G,

One of the solutions is a unique tool.

The second one would be using multi-row formula and filter. I have prepared a workflow using both functions;