Hi,
I have played around with COUNTIF, SUM, PERMUT & COMBIN in order to get my own end results and being as I use Excel on a limited basis, I am in no way, shape or form a "formula/figure expert" person.
What I am looking to do...
I would like to enter my own (4) digit numbers and insert a formula to give me all possible combinations for those (4) digit numbers. Total numbers to be used would be 8. (1 through 8, each number occurring only 1 time in each line, no duplicates on a line)
Example: I am trying to get the actual number combinations listed - NOT just the total combinations available
4-3-2-1......getting me 3-2-1-4, 2-3-4-1, 4-1-2-3, etc...
8-7-2-4......getting me 7-2-4-8, 2-4-8-7, 7-4-2-8, etc...
5-2-3-1......getting me 5-1-2-3, 3-2-5-1, 2-5-3-1, etc...
The next step would to be able to pull out numbers that repeat (either 2 or three times) in each combination (like the 1-2 & 3 in the 1st & 2nd example)
As my username states - I am looking for the step by step (actual way to put it on spreadsheet) coding, as stated I have VERY Basic experience and this is for my job for parts coding
THANK YOU SOOOOO MUCH!!!
Bookmarks