I need to add macro buttons labeled as “Singles” and "Sort"; “Doubles” and "Sort" and “Triples” and "Sort".
Once the singles button is clicked it will list only the unique 3 digit numbers concatenated based upon if 4, 5, 6, 7, 8, 9 or 10 different numbers are selected as the source (e.g. 123 or 456). Once the sort button is clicked it will sort only the singles results listed from smallest to largest. Also I need a count of the singles results.
Once the doubles button is clicked it will list only the unique 3 digit numbers concatenated based upon only if two or more numbers that repeat, (e.g. 223, 331) out of the 4, 5, 6, 7, 8, 9 or 10 numbers selected as the source. Once the sort button is clicked it will sort only the doubles results listed from smallest to largest. Also I need a count of the doubles results, if any.
Once the triples button is clicked it will list only the unique 3 digit numbers concatenated based upon only if all three numbers repeat, (e.g. 333, 444) out of the 4, 5, 6, 7, 8, 9 or 10 numbers selected as the source. Once the sort button is clicked it will sort only the triples results listed from smallest to largest. Also I need a count of the triples results, if any.
Sheet 1: Offers an example and more detailed explanation.
Sheet 2: Has the current assigned macro which is set to distribute only unique numbers. It will list doubles (numbers with 2 or more of the same digits) and it will list triples (numbers that repeat all three digits) in the total list of results.