But each incremental example Im gonna review what weve done before but hopefully go a little bit further. Combinations are generated in lexicographical order. Solve the equation to find the number of combinations.
Select a cell in your list and then go to the Data tab and select the From TableRange command in the Get Transform Data section.
Stick the last number on the end. Click Kutools Insert List All Combinations see screenshot. The length is the potential of the field. Plus you can even choose to have the result set sorted in ascending or descending order.