N nIgOl New Member Joined Jun 1, 2005 Messages 8 Nov 29, 2005 #1 Hi everyone, How can I produce a list of 4 digit numbers, where digits are not repeated? to give an example: 0124 0239 1236 2345 2346 etc.. etc.. but wouldn't include something like 0023 1223 Hopefully I explain myself.
Hi everyone, How can I produce a list of 4 digit numbers, where digits are not repeated? to give an example: 0124 0239 1236 2345 2346 etc.. etc.. but wouldn't include something like 0023 1223 Hopefully I explain myself.
G GorD Well-known Member Joined Jan 17, 2004 Messages 1,446 Nov 29, 2005 #2 See this thread. http://www.mrexcel.com/board2/viewtopic.php?t=179001&highlight= Set A1 to C for combinations set A2 to 4 (numbers to select) and list the 10 digits 0-9 below The macro will do the rest
See this thread. http://www.mrexcel.com/board2/viewtopic.php?t=179001&highlight= Set A1 to C for combinations set A2 to 4 (numbers to select) and list the 10 digits 0-9 below The macro will do the rest