Producing a list of 4 digit numbers

nIgOl

New Member
Joined
Jun 1, 2005
Messages
8
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.
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,118,069
Messages
5,570,009
Members
412,304
Latest member
citrus
Top