ColSort(Range,[SortCol],[Ascend])
Sorts the rows of a range using the values in a specified column. Range is the range to sort. SortCol specifies the column to sort by. If not specified then it defaults to SortCol=1. Ascend specifies whether the rows are sorted ascending (Ascend <> 0) or descending (Ascend=0). If not specified then it defaults to Ascend=1.
Range
| |
|
|
|
|
|
|
|
|
|
| |
Country |
TFR |
R |
Alpha |
P |
H |
Delay |
Stopping |
|
| |
Afghanistan |
5.72 |
0.290589 |
13.00507 |
24.63996 |
39.08151 |
4.639957 |
-1.76154 |
|
| |
Albania |
2.27 |
0.166136 |
15.51535 |
26.7616 |
34.13652 |
6.761604 |
4.244284 |
|
| |
Algeria |
2.63 |
0.17114 |
13.93767 |
27.1674 |
35.63377 |
7.167405 |
2.949936 |
|
| |
American Samoa |
3.4 |
0.228138 |
13.38086 |
26.94889 |
34.70073 |
6.948893 |
3.773713 |
|
| |
Andorra |
1.26 |
0.099852 |
15.22119 |
29.98864 |
35.06823 |
9.988638 |
4.926085 |
|
| |
Angola |
6.43 |
0.314661 |
11.31434 |
24.81307 |
39.39524 |
4.813066 |
-1.98871 |
|
| |
Anguilla |
1.77 |
0.125609 |
13.4111 |
28.84279 |
35.09294 |
8.842791 |
4.328457 |
|
| |
Antig & Barb |
2.29 |
0.154319 |
8.478101 |
21.80567 |
30.22622 |
1.805671 |
5.676614 |
|
| |
Argentina |
2.41 |
0.139641 |
5.654784 |
27.2739 |
35.68839 |
7.273896 |
2.948557 |
|
| |
Armenia |
1.53 |
0.164481 |
18.60237 |
18.60257 |
26.809 |
-1.39743 |
7.49229 |
|
| |
Aruba |
1.8 |
0.117888 |
11.62507 |
27.03405 |
34.53762 |
7.034045 |
3.979406 |
|
| |
Australia |
1.77 |
0.125627 |
11.87729 |
30.13009 |
35.68948 |
10.13009 |
4.375561 |
|
| |
Austria |
1.4 |
0.102684 |
13.66067 |
27.40404 |
33.79127 |
7.404042 |
4.910751 |
|
| |
Azerbaijan |
2.29 |
0.191994 |
17.06999 |
22.72184 |
30.65458 |
2.72184 |
5.706337 |
|
| |
|
|
|
|
|
|
|
|
|
|
ColSort
| |
|
|
|
|
|
|
|
|
|
| SortCol |
7 |
|
|
|
|
|
|
|
|
Ascend<>0 Ascending.=0 Descending |
0 |
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
| ColSort |
|
|
|
|
|
|
|
|
|
| |
Country |
TFR |
R |
Alpha |
P |
H |
Delay |
Stopping |
|
| |
Australia |
1.77 |
0.125627 |
11.87729 |
30.13009 |
35.68948 |
10.13009 |
4.375561 |
|
| |
Andorra |
1.26 |
0.099852 |
15.22119 |
29.98864 |
35.06823 |
9.988638 |
4.926085 |
|
| |
Anguilla |
1.77 |
0.125609 |
13.4111 |
28.84279 |
35.09294 |
8.842791 |
4.328457 |
|
| |
Austria |
1.4 |
0.102684 |
13.66067 |
27.40404 |
33.79127 |
7.404042 |
4.910751 |
|
| |
Argentina |
2.41 |
0.139641 |
5.654784 |
27.2739 |
35.68839 |
7.273896 |
2.948557 |
|
| |
Algeria |
2.63 |
0.17114 |
13.93767 |
27.1674 |
35.63377 |
7.167405 |
2.949936 |
|
| |
Aruba |
1.8 |
0.117888 |
11.62507 |
27.03405 |
34.53762 |
7.034045 |
3.979406 |
|
| |
American Samoa |
3.4 |
0.228138 |
13.38086 |
26.94889 |
34.70073 |
6.948893 |
3.773713 |
|
| |
Albania |
2.27 |
0.166136 |
15.51535 |
26.7616 |
34.13652 |
6.761604 |
4.244284 |
|
| |
Angola |
6.43 |
0.314661 |
11.31434 |
24.81307 |
39.39524 |
4.813066 |
-1.98871 |
|
| |
Afghanistan |
5.72 |
0.290589 |
13.00507 |
24.63996 |
39.08151 |
4.639957 |
-1.76154 |
|
| |
Azerbaijan |
2.29 |
0.191994 |
17.06999 |
22.72184 |
30.65458 |
2.72184 |
5.706337 |
|
| |
Antig & Barb |
2.29 |
0.154319 |
8.478101 |
21.80567 |
30.22622 |
1.805671 |
5.676614 |
|
| |
Armenia |
1.53 |
0.164481 |
18.60237 |
18.60257 |
26.809 |
-1.39743 |
7.49229 |
|
| |
|
|
|
|
|
|
|
|
|
|