Get new list of numbers, stating from 0 to bigger number increasing by 1

motilulla

Well-known Member
Joined
Feb 13, 2008
Messages
2,354
Office Version
  1. 2010
Hello,

I got list of numbers in the column "C" which has always-smaller number "0" max number with no limits (max list of numbers in the column "C" could be max 170-175),

I want to have new list of numbers as show in the Column "D" which must look the smaller number, which is 0, give a number 1, next find 2nd larger number in the column "D" and give a number 2, next find 3rd larger number in the column "D" and give a number 3.... and so on...

*ABCDEF
1
2
3
4NumbersNew List
57750
613261
71817
88051
97549
1020869
1156
1224072
136445
1412
159353
163330
173128
18910
195039
201514
215441
225642
2389
2416464
252120
2667
274637
2891181
293732
302927
3121770
3245
337148
3413962
3514763
361716
372624
385743
399854
404435
4111157
4278
4310856
4412058
4558479
4640877
4728975
4820368
4934676
5001
5112560
529252
532422
541615
5580480
561918
5726074
583833
591413
602725
611312
621011
6325873
646746
652221
6617366
672826
6810155
694536
706947
713531
725844
733229
7423
7522771
7619567
773934
782523
7912159
804738
8134
8253978
835140
8416665
852019
86
87
88

For example, the sample image is attached.

Thank you all.

I am using Excel 2000

Regards,
Moti
 

Attachments

  • New list of nuumbers.png
    New list of nuumbers.png
    42.1 KB · Views: 8

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
How about
Excel Formula:
=RANK(C5,$C$5:$C$175,1)
 
Upvote 0
Solution
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,272
Members
448,558
Latest member
aivin

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