Macro for permutation and combination

**anjanjb** · 10-27-2010, 02:57 PM

Hi,

I have a numbers in a column and i want a macro which can get me all permutation and combination values, Eg Cell A1 has a value of 1005, cell A2 has 201, cell A3 has 1375, is there a macro which can get me how many permutation and combination values can be possible for all the Cells diffenently like how many Permutation and combination is possible for A1, then how many Permutation and combination is possible for B1, then how many Permutation and combination is possible for C1 and so on....

Please help

Thanks & Regards,
Anjan

**shg** · 10-27-2010, 03:43 PM

For example, ?

**anjanjb** · 10-27-2010, 04:58 PM

I have attached the Excel for Example, Col A has the Values, and i want a macro that can calculate the possible permutation and combination values for each cell.