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

admin管理员组

文章数量:1297113

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.

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.

• combinations

Share Improve this question Follow asked Feb 11 at 16:29 Phani KalakondaPhani Kalakonda 1 1

• Please provide enough code so others can better understand or reproduce the problem. – Community Bot Commented Feb 12 at 0:47

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

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

本文标签： I have a column in excel and I want to get all sets of combinations in another row or columnStack Overflow