Is it possible to make exact combinations of different elements dynamically.

Is it possible to make exact combinations of different elements dynamically.

I can get the count of the pairs using the COMBIN Function.

Example :
Column A Column B Column C
Elements Pairs No of Pairs that can be formed
A 2 15
B
C
D
E
F

[ C2=COMBIN(COUNTA($A:$A)-1,$B$2) ]

However, I want some Logic/Formulas in Excel and not in VBA preferably which can display the values..

Column D Column E Column F Column G Column H
Pair
I II III IV V
AB BC CD DE EF
AC BD CE DF
AD BE CF
AE BF
AF

The Roman numeral indicate the Ist, IInd, IIIrd, IVth and Vth pairs respectively.

Is it possible to display the different combinations the way it is shown above for different Count of elements as well as the Number of Pairs required..

Anyone, I know this is indeed very tough considering that it should also be Dynamic...

Why the prepossession against VBA?

Originally Posted by shg

Why the prepossession against VBA?

Shg,

I have nothing against VBA, however I have better command in MS Excel and not able to comprehend VBA completely due to time constraints.

With Excel I can have complete control of the coding or program..
However, I do understand the fact that there are some things which would only be possible in VBA and not in Excel alone but since I am not fully conversant with VBA, i request for help in Excel..

I somehow not been able to devote time to VBA...

Anyways is this possible in Excel?

Originally Posted by Simon Lloyd

Somehow i don't think you want to looking back over the many posts you have been helped with!Yes it's possible......VBA is part of Excel.

Simon,

I would really appreciate if you could provide a solution in either Excel Formulas or VBA, but please provide explanation as I really am not so comfortable wit VBA..

Per my query the No of elements as well as the Pair Number both can change...

I am making a point to understand VBA, however it will take me some time.
So please help me in this...