Removing common records

[SCK]

Hi All. I need yet another help. I am trying to remove duplicate records in field3 based on field 1. Please help.

[Emil_Kos · Accepted solution]

Hi @SCK,

I have prepared the solutions for you using multi row formula:

[atcodedog05 · Accepted solution]

Hi @SCK ,

Here is a approach using Unique Tool.

I am guessing Field-1 is Data. If not change the field in unique field.

Input: File given by you.

Output:

Pst... 2nd row name is spelled differently so its unique.

And as you have seen sorting order doesnt matter.

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[AbhilashR · Accepted solution]

Hi @SCK, a less elegant approach compared to @Emil_Kos but sharing it just to showcase the variety of ways you can achieve your solution.

[SCK]

Thank you so much everyone. It all worked perfectly fine. 🙂

[atcodedog05]

Happy to help 🙂

Cheers and happy analyzing 😀