hat
Pou egzanp mwen bezwen lis tout konbinezon posib nan twa lis nan chenn nan A2: A6, B2: B8, ak C2: C6 kòm piki ekran swiv yo montre. Gen konbinezon 175 ak twa lis sa yo, epi li pral byen tan konsome ak erè ki gen tandans fè lis tout nan yo pa pwòp mwen. Men, Kutools pou Excel a Lis tout konbinezon sèvis piblik ka ede nou fasil jenere ak lis tout konbinezon posib nan bay lis nan yon ti tan nan Excel.
eng
For example, I need to list all possible combinations of three lists in ranges of A2:A6, B2:B8, and C2:C6 as following screen shot shown. There are 175 combinations with these three lists, and it will be quite time-consuming and error-prone to list all of them by my own. But Kutools for Excel’s List All Combinations utility can help us easily generate and list all possible combinations of given lists in a short time in Excel.