Thread: Creating combinations
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sweetas01 sweetas01 is offline
external usenet poster
  
Posts: 1
Default Creating combinations
I want to create combinations from the below variables (A1:A5 & X, Y and Z
being cell references). Is there a formula that will allow me to do this?

X Y Z
A1 A G M
A2 D G
A3 A D G
A4 I
A5 A I
Reply With QuoteReply With Quote