Remove duplicated combinations

[slinky123]

Hi All,

I have the following data:

Product A	Product B	Count
123	456	3
456	123	3
789	568	4
789	124	5
568	789	4
124	789	5

I want to be able to remove any duplicated combinations (i.e. Rows 1 and 2 are the same, just in reverse order): 123, 456 = 456, 123. The logic being that the same products are being sold with each other.

Therefore my target output looks  like this:

Product A	Product B	Count
123	456	3
789	568	4
124	789	5

Any ideas?

Thanks in advance!

Scott

[jasperlch · Accepted solution]

Hi, I think this will do:

[slinky123]

Amazing! Thanks so much for the quick response! Works perfectly!