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...
For example, the sample image is attached.
Thank you all.
I am using Excel 2000
Regards,
Moti
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...
* | A | B | C | D | E | F |
1 | ||||||
2 | ||||||
3 | ||||||
4 | Numbers | New List | ||||
5 | 77 | 50 | ||||
6 | 132 | 61 | ||||
7 | 18 | 17 | ||||
8 | 80 | 51 | ||||
9 | 75 | 49 | ||||
10 | 208 | 69 | ||||
11 | 5 | 6 | ||||
12 | 240 | 72 | ||||
13 | 64 | 45 | ||||
14 | 1 | 2 | ||||
15 | 93 | 53 | ||||
16 | 33 | 30 | ||||
17 | 31 | 28 | ||||
18 | 9 | 10 | ||||
19 | 50 | 39 | ||||
20 | 15 | 14 | ||||
21 | 54 | 41 | ||||
22 | 56 | 42 | ||||
23 | 8 | 9 | ||||
24 | 164 | 64 | ||||
25 | 21 | 20 | ||||
26 | 6 | 7 | ||||
27 | 46 | 37 | ||||
28 | 911 | 81 | ||||
29 | 37 | 32 | ||||
30 | 29 | 27 | ||||
31 | 217 | 70 | ||||
32 | 4 | 5 | ||||
33 | 71 | 48 | ||||
34 | 139 | 62 | ||||
35 | 147 | 63 | ||||
36 | 17 | 16 | ||||
37 | 26 | 24 | ||||
38 | 57 | 43 | ||||
39 | 98 | 54 | ||||
40 | 44 | 35 | ||||
41 | 111 | 57 | ||||
42 | 7 | 8 | ||||
43 | 108 | 56 | ||||
44 | 120 | 58 | ||||
45 | 584 | 79 | ||||
46 | 408 | 77 | ||||
47 | 289 | 75 | ||||
48 | 203 | 68 | ||||
49 | 346 | 76 | ||||
50 | 0 | 1 | ||||
51 | 125 | 60 | ||||
52 | 92 | 52 | ||||
53 | 24 | 22 | ||||
54 | 16 | 15 | ||||
55 | 804 | 80 | ||||
56 | 19 | 18 | ||||
57 | 260 | 74 | ||||
58 | 38 | 33 | ||||
59 | 14 | 13 | ||||
60 | 27 | 25 | ||||
61 | 13 | 12 | ||||
62 | 10 | 11 | ||||
63 | 258 | 73 | ||||
64 | 67 | 46 | ||||
65 | 22 | 21 | ||||
66 | 173 | 66 | ||||
67 | 28 | 26 | ||||
68 | 101 | 55 | ||||
69 | 45 | 36 | ||||
70 | 69 | 47 | ||||
71 | 35 | 31 | ||||
72 | 58 | 44 | ||||
73 | 32 | 29 | ||||
74 | 2 | 3 | ||||
75 | 227 | 71 | ||||
76 | 195 | 67 | ||||
77 | 39 | 34 | ||||
78 | 25 | 23 | ||||
79 | 121 | 59 | ||||
80 | 47 | 38 | ||||
81 | 3 | 4 | ||||
82 | 539 | 78 | ||||
83 | 51 | 40 | ||||
84 | 166 | 65 | ||||
85 | 20 | 19 | ||||
86 | ||||||
87 | ||||||
88 |
For example, the sample image is attached.
Thank you all.
I am using Excel 2000
Regards,
Moti