Increasing Combination

dinesh4you

New Member
Joined
Aug 6, 2012
Messages
31
Office Version
  1. 365
Platform
  1. Mobile
Dear experts, if i have fegures 1 to 0 zero is bigger then 9 what will be formula of combination in 4 digits? For example 1234, 1235, 1236....... 6789, 7890.....
I want to search how many 4 digit combination can be create from 1234567890 where zero is highest number and 4 digit all sets are in increasing order. For example 1234 is right but 1243 is wrong.
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
there are 210 combinations, choose 4 in 10:
工作簿1
ABCD
11234
21235
31236
41237
51238
61239
71230
81245
91246
101247
111248
121249
131240
141256
151257
161258
171259
181250
191267
201268
211269
221260
231278
241279
251270
261289
271280
281290
291345
301346
311347
321348
331349
341340
351356
361357
371358
381359
391350
401367
411368
421369
431360
441378
451379
461370
471389
481380
491390
501456
511457
521458
531459
541450
551467
561468
571469
581460
591478
601479
611470
621489
631480
641490
651567
661568
671569
681560
691578
701579
711570
721589
731580
741590
751678
761679
771670
781689
791680
801690
811789
821780
831790
841890
852345
862346
872347
882348
892349
902340
912356
922357
932358
942359
952350
962367
972368
982369
992360
1002378
1012379
1022370
1032389
1042380
1052390
1062456
1072457
1082458
1092459
1102450
1112467
1122468
1132469
1142460
1152478
1162479
1172470
1182489
1192480
1202490
1212567
1222568
1232569
1242560
1252578
1262579
1272570
1282589
1292580
1302590
1312678
1322679
1332670
1342689
1352680
1362690
1372789
1382780
1392790
1402890
1413456
1423457
1433458
1443459
1453450
1463467
1473468
1483469
1493460
1503478
1513479
1523470
1533489
1543480
1553490
1563567
1573568
1583569
1593560
1603578
1613579
1623570
1633589
1643580
1653590
1663678
1673679
1683670
1693689
1703680
1713690
1723789
1733780
1743790
1753890
1764567
1774568
1784569
1794560
1804578
1814579
1824570
1834589
1844580
1854590
1864678
1874679
1884670
1894689
1904680
1914690
1924789
1934780
1944790
1954890
1965678
1975679
1985670
1995689
2005680
2015690
2025789
2035780
2045790
2055890
2066789
2076780
2086790
2096890
2107890
Sheet1
 
Upvote 0

Forum statistics

Threads
1,223,933
Messages
6,175,476
Members
452,646
Latest member
tudou

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top