CODEWITHSUNDEEP
combinations
Phani Kalakonda
Phani Kalakonda

Reputation: 1

I have a column in excel and I want to get all sets of combinations in another row or column

Here is my column enter image description here I am looking for a formula to get all combinations separated by "/" Example: SE/XE SE/SX SE/EX XE/EX SE/XE/EX and so on

I have so far been able to only do it manually. I am looking for an excel formula to do this.

Upvotes: 0

Views: 21

Answers (1)

Cal
Cal

Reputation: 1

I have made some assumptions since your question does not specify the types of combinations, e.g. if you're only looking for unique pairs, if the combination can/cannot repeat the same characters...

Organize your unique values (SE, XE, SX, EX) into a column. Next, using the filter function, display an array across each row based on that rows unique value. The filter and &"/" combines the row's unique value with the rest of the other values from the original values list by using the <> (not equal to) operator.

=TOROW((A2&"/"&FILTER($A$2:$A$5,A2<>$A$2:$A$5)))

Then stack into a column for tidiness.

=TOCOL(C2:E5)

Demonstration

Upvotes: 0

Related Questions