Permutation Combination

**Amarjeet Singh** · 03-17-2011, 09:07 AM

Hi ,

I have List A and List B , I want to produce the result as shown in the Output Column, Is there any formula to have this permutation Combination output?

Thanks in advance for your help.

**ChemistB** · 03-17-2011, 09:38 AM

I think there may be a shorter formula using LOOKUP but this solution should work

=(INDEX($A$2:$A$100,INT(((ROW(A1)-1)/COUNT($B$2:$B$100))+1))&"."&INDEX($B$2:$B$100,MOD(ROW(A1)-1,5)+1))+0

Does that work for you?

**6StringJazzer** · 03-17-2011, 12:54 PM

This extends ChemistB's solution to be generalized to work with any number of entries in either column. It assumes all entries are numbers, and headers in row 1, as shown in the example. Use in D2 and copy down as far as needed.

Please Login or Register  to view this content.

**Amarjeet Singh** · 03-18-2011, 04:43 AM

Originally Posted by ChemistB

I think there may be a shorter formula using LOOKUP but this solution should work

=(INDEX($A$2:$A$100,INT(((ROW(A1)-1)/COUNT($B$2:$B$100))+1))&"."&INDEX($B$2:$B$100,MOD(ROW(A1)-1,5)+1))+0

Does that work for you?

Many Thanks this works.

Amarjeet