Combinations of subtraction between members of same subgroup in several groups.

Hello, I need a help with combinations. I have a data that looks like:

1	a	data_1a
1	b	data_1b
1	c	data_1c
2	a	data_2a
2	b	data_2b
3	a	data_3a

Is there a way to automatically make all possible combinations of deduction between members of group 1 only then of group 2 only etc? So it would look like:

data_1a-data_1b
data_1a-data_1c
data_1b-data_1c
data_2a-data_2b
data_2a-data_2c
data_2b-data_2c

Combinations between letter indicators but not between number indicators.

Thank you for help in advance! BTW groups are different in size starting from 2 till 8 members. Won't this cause any troubles?

Are the two characters in each row in the same or adjacent cells? Always best to post an example workbook to avoid ambiguity.

Hello Mrice! My initial post was misleading a bit sorry for that. They are in adjacent cells, looks like this:

1	a	data_1a
1	b	data_1b
1	c	data_1c
2	a	data_2a
2	b	data_2b
3	a	data_3a

So what i need is to have data_1a-data_1b; data_1a-data_1c; data_1b-data_1c; data_2a-data_2b; etc

Combinations between letter indicators but not between number indicators.

What about the other combinations:
data_1b-data_1a
data_1c-data_1a
data_1c-data_1b

Try this

Please Login or Register  to view this content.

I've assumed that there is a header row and that column E is OK to dump the combinations into.