Filter out the Rows with the same combination in an different order

I would like to filter duplicate combinations in an different order. In the example the "C and A" and "B and A" combination should be filtered out. Does anyone have an idea?

Thank you in advance

Preparation

Accepted answers

atcodedog05

Hi @Robinvm

Here is how you can do it.

Workflow:

Hope this helps : )

Duplicate combo.yxmd

All comments

messi007

@Robinvm,

I added one row in order to test.

1- I added a formula to concat both column

2- I added a join between two keys column if it match I will not take them if not I'll get them (Last row in our case)

Attached the workflow,

Hope this helps!

Regards

CheckDuplicate.yxmd

atcodedog05

Hi @Robinvm

Here is how you can do it.

Edit: similar to @messi007 I have just added a hyphen (-) in between so that matches are exact

Workflow:

Hope this helps : )

Duplicate combo.yxmd

Robinvm

Thank you for your time @atcodedog05 and @messi007 ,

Maybe I expressed myself misleadingly.

I would like to have this Input:

And get this Output:

I just want to remove these rows, which I already have in a different order.

Thank you

atcodedog05

Hi @Robinvm

Here is how you can do it.

Workflow:

Hope this helps : )

Duplicate combo.yxmd

Robinvm

@atcodedog05 Exactly what I want. Thank you very much 😊

atcodedog05

Happy to help : ) @Robinvm

Cheers and have a nice day!

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335