How to create lists for custom sort in VBA

W

Waimea

Active Member
Joined
Jun 30, 2018
Messages
465
Office Version
  1. 365
Platform
  1. Windows
Hi, I am currently using custom sort to sort a big list.

I want to apply the custom sort 39 or n times.

Code: 
Sub SortCity2()
  
range("A42:H81").Select


ActiveWorkbook.worksheets("Snabb2").Sort.SortFields.Clear


ActiveWorkbook.worksheets("Snabb2").Sort.SortFields.add key:=range("A42"), SortOn:=xlSortOnValues, _
    Order:=xlAscending, CustomOrder:="City2, City1, City3, City4, City5, City6, City7, City8, City9, City10", City11, City12, City13, City14, City15, City16, City17, City18, City19, City20, City21, City22, City23, City24, City25, City26, City27, City28, City29, City30, City31, City32, City33, City34, City35, City36, City37, City38, City39, City40", DataOption:=xlSortNormal
    
With ActiveWorkbook.worksheets("Snabb2").Sort
.SetRange range("A42:H81")
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With

End Sub

The sorted list contains 40 * 40 cities for a total of 1600 rows + 1 header row.

The list starts with City1 to City40, then it starts over at City2, City1, City3, ..., City40.

City1, City2, City3, City4, City5, City6, City7, City8, City9, City10", City11, City12, City13, City14, City15, City16, City17, City18, City19, City20, City21, City22, City23, City24, City25, City26, City27, City28, City29, City30, City31, City32, City33, City34, City35, City36, City37, City38, City39, City40

City2, City1, City3, City4, City5, City6, City7, City8, City9, City10", City11, City12, City13, City14, City15, City16, City17, City18, City19, City20, City21, City22, City23, City24, City25, City26, City27, City28, City29, City30, City31, City32, City33, City34, City35, City36, City37, City38, City39, City40

City3, City1, City2, City4, City5, City6, City7, City8, City9, City10", City11, City12, City13, City14, City15, City16, City17, City18, City19, City20, City21, City22, City23, City24, City25, City26, City27, City28, City29, City30, City31, City32, City33, City34, City35, City36, City37, City38, City39, City40

City4, City1, City2, City3, City5, City6, City7, City8, City9, City10", City11, City12, City13, City14, City15, City16, City17, City18, City19, City20, City21, City22, City23, City24, City25, City26, City27, City28, City29, City30, City31, City32, City33, City34, City35, City36, City37, City38, City39, City40

Edit: In my workbook the city names doesn't contain the numbers after the cities.
 
Last edited:

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.
Sort by date Sort by votes
Perhaps a sub or function that passes the array, the number of items and the nth position would work?

I don't know however where to start to create such a sub or function?

Code: 
Function CUSTOMSORT(myArray As Array, numberOfItems as Integer, nthPosition As Integer) As Variant
' code to change the value of the 1 first row to the nth position

End function
 
Last edited:
Upvote 0
Could someone give me some pointers on how to go about creating a sub that places the nth element first in a list?
 
Upvote 0
I have created an array with 40 items in it, with index at 0.

I can access the arrays positions by myarray(0) to myarray(39).

I want to use the array with the nth item as myarray(nth).

I guess I could create 40 arrays but that seems like a lot of manual work?
 
Upvote 0
I don't know how to use custom sort to solve your problem.
How about using a temporary helper column?
I can write a macro to insert a sequence of numbers into the helper column so you can sort data according to your requirement above.
 
Upvote 0
Hi Akuini,

thank you for your reply! I am not using custom sort to solve this, I am trying to create automated lists to use with custom sort.

Can you explain how you would solve it using a helper column?
 
Upvote 0
Waimea said:
Hi Akuini,

thank you for your reply! I am not using custom sort to solve this, I am trying to create automated lists to use with custom sort.

Can you explain how you would solve it using a helper column?
Click to expand...

For example try this:

Code: 
Sub a1081405a()
'https://www.mrexcel.com/forum/excel-questions/1081405-how-create-lists-custom-sort-vba.html
Dim i As Long, n As Long, m As Long, k As Long, c As Long
Dim x As String
Dim va As Variant, z As Variant
Dim dar As Object

va = Range("A1", Cells(Rows.count, "A").End(xlUp))
Set dar = CreateObject("System.Collections.Sortedlist")
    For i = 1 To UBound(va, 1)
        If Not dar.contains(va(i, 1)) Then
         dar.Add va(i, 1), 1
        End If
    Next

For c = 0 To dar.count - 1
    n = 10101 + m
        For k = 0 To dar.count - 1
             z = dar.GetKey(k)
                For i = 1 To UBound(va, 1)
                    If va(i, 1) = z Then
                        va(i, 1) = n
                        n = n + 1
                        Exit For
                    End If
                Next
        Next
    m = m + 100
Next

For i = 1 To UBound(va, 1)
    x = CStr(va(i, 1))
    If Mid(x, 2, 2) = Mid(x, 4, 2) Then
        va(i, 1) = Left(x, Len(x) - 1) & "0"
    End If
Next

Range("C1").Resize(UBound(va, 1), 1) = va

End Sub


EXAMPLE:


Book1
A
1Harry
2Mark
3Mark
4Harry
5Aaden
6Aaden
7Leandro
8Leandro
9Aaden
10Harry
11Leandro
12Leandro
13Aaden
14Mark
15Harry
16Mark
Sheet1


AFTER RUNNING THE MACRO:


Book1
ABC
1Harry10102
2Mark10104
3Mark10204
4Harry10200
5Aaden10100
6Aaden10201
7Leandro10103
8Leandro10203
9Aaden10301
10Harry10302
11Leandro10300
12Leandro10403
13Aaden10401
14Mark10304
15Harry10402
16Mark10400
Sheet1


YOU CAN SORT BY COLUMN C, THE RESULT:


Book1
ABC
1Aaden10100
2Harry10102
3Leandro10103
4Mark10104
5Harry10200
6Aaden10201
7Leandro10203
8Mark10204
9Leandro10300
10Aaden10301
11Harry10302
12Mark10304
13Mark10400
14Aaden10401
15Harry10402
16Leandro10403
Sheet1
 
Upvote 0
Hi, thank you for your reply! I am not sure I get what you are doing, you are creating a helper column with unique rankings in them but after that I don't understand?

I want to run custom sort 39 or 40 times, each time I want the first item/city/name to change.

Ex.

First custom sort:
Aaden (1), Harry (2), Leandro (3), Mark (4), Harry (5)

Second custom sort:
Harry (2), Aaden (1), Leandro (3), Mark (4), Harry (5)

Third custom sort:
 Leandro (3), Aaden (1), Harry (2), Mark (4), Harry (5)

Fourth custom sort:
Mark (4), Aaden (1), Harry (2), Leandro (3), Harry (5)

Fifth custom sort:
Harry (5), Aaden (1), Harry (2), Leandro (3), Mark (4)

EDIT: I got it wrong!
 
Last edited:
Upvote 0
The sorted list contains 40 * 40 cities for a total of 1600 rows + 1 header row.
Click to expand...

Hm, I might misunderstand something
You have data that contains 40 unique cities in 1600 rows, right?
 
Upvote 0
Hi, I think it is my fault that I explained it poorly and I apologize.

I have 1600 rows where the city1 to city40 repeats in batches of 40. I am using VBA to insert formulas into my worksheet and for every 40th row I want to change the reference what is being used in the formulas.

Perhaps you could help me to figure out how to offset
Code: 
"=SUMPRODUCT($B$2:$H$2,B2:H2)"
so that it increases with 40 rows but with 40 + 1 rows for the reference. The reference is B2:H2 for the first 40 rows, the reference is B42:H42 for the next 40 rows and so on.

[TABLE="width: 448"]
<tbody>[TR]
[TD="class: xl63, width: 64"]Name [/TD]
[TD="class: xl63, width: 64"] Metric1[/TD]
[TD="class: xl63, width: 64"] Metric2[/TD]
[TD="class: xl63, width: 64"] Metric3[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl66"]City1[/TD]
[TD="class: xl66, align: right"]65[/TD]
[TD="class: xl66, align: right"]71[/TD]
[TD="class: xl66, align: right"]95[/TD]
[TD][/TD]
[TD="colspan: 2"]City1 is at the top[/TD]
[/TR]
[TR]
[TD="class: xl67"]City2[/TD]
[TD="class: xl67, align: right"]45[/TD]
[TD="class: xl67, align: right"]63[/TD]
[TD="class: xl67, align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City3[/TD]
[TD="class: xl67, align: right"]66[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD="class: xl67, align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City4[/TD]
[TD="class: xl67, align: right"]28[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD="class: xl67, align: right"]54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City5[/TD]
[TD="class: xl67, align: right"]30[/TD]
[TD="class: xl67, align: right"]12[/TD]
[TD="class: xl67, align: right"]19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City6[/TD]
[TD="class: xl67, align: right"]76[/TD]
[TD="class: xl67, align: right"]34[/TD]
[TD="class: xl67, align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City7[/TD]
[TD="class: xl67, align: right"]74[/TD]
[TD="class: xl67, align: right"]24[/TD]
[TD="class: xl67, align: right"]47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City8[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]46[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City9[/TD]
[TD="class: xl67, align: right"]55[/TD]
[TD="class: xl67, align: right"]6[/TD]
[TD="class: xl67, align: right"]24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City10[/TD]
[TD="class: xl67, align: right"]67[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]35[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City11[/TD]
[TD="class: xl67, align: right"]85[/TD]
[TD="class: xl67, align: right"]1[/TD]
[TD="class: xl67, align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City12[/TD]
[TD="class: xl67, align: right"]35[/TD]
[TD="class: xl67, align: right"]16[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City13[/TD]
[TD="class: xl67, align: right"]39[/TD]
[TD="class: xl67, align: right"]96[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City14[/TD]
[TD="class: xl67, align: right"]39[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]69[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City15[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD="class: xl67, align: right"]9[/TD]
[TD="class: xl67, align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City16[/TD]
[TD="class: xl67, align: right"]12[/TD]
[TD="class: xl67, align: right"]50[/TD]
[TD="class: xl67, align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City17[/TD]
[TD="class: xl67, align: right"]77[/TD]
[TD="class: xl67, align: right"]97[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City18[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD="class: xl67, align: right"]21[/TD]
[TD="class: xl67, align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City19[/TD]
[TD="class: xl67, align: right"]13[/TD]
[TD="class: xl67, align: right"]9[/TD]
[TD="class: xl67, align: right"]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City20[/TD]
[TD="class: xl67, align: right"]13[/TD]
[TD="class: xl67, align: right"]20[/TD]
[TD="class: xl67, align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City21[/TD]
[TD="class: xl67, align: right"]68[/TD]
[TD="class: xl67, align: right"]69[/TD]
[TD="class: xl67, align: right"]33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City22[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD="class: xl67, align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City23[/TD]
[TD="class: xl67, align: right"]51[/TD]
[TD="class: xl67, align: right"]82[/TD]
[TD="class: xl67, align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City24[/TD]
[TD="class: xl67, align: right"]3[/TD]
[TD="class: xl67, align: right"]30[/TD]
[TD="class: xl67, align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City25[/TD]
[TD="class: xl67, align: right"]9[/TD]
[TD="class: xl67, align: right"]76[/TD]
[TD="class: xl67, align: right"]98[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City26[/TD]
[TD="class: xl67, align: right"]71[/TD]
[TD="class: xl67, align: right"]59[/TD]
[TD="class: xl67, align: right"]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City27[/TD]
[TD="class: xl67, align: right"]44[/TD]
[TD="class: xl67, align: right"]54[/TD]
[TD="class: xl67, align: right"]97[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City28[/TD]
[TD="class: xl67, align: right"]35[/TD]
[TD="class: xl67, align: right"]31[/TD]
[TD="class: xl67, align: right"]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City29[/TD]
[TD="class: xl67, align: right"]80[/TD]
[TD="class: xl67, align: right"]77[/TD]
[TD="class: xl67, align: right"]96[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City30[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD="class: xl67, align: right"]15[/TD]
[TD="class: xl67, align: right"]90[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City31[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]66[/TD]
[TD="class: xl67, align: right"]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City32[/TD]
[TD="class: xl67, align: right"]3[/TD]
[TD="class: xl67, align: right"]98[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City33[/TD]
[TD="class: xl67, align: right"]63[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD="class: xl67, align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City34[/TD]
[TD="class: xl67, align: right"]77[/TD]
[TD="class: xl67, align: right"]64[/TD]
[TD="class: xl67, align: right"]90[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City35[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD="class: xl67, align: right"]3[/TD]
[TD="class: xl67, align: right"]66[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City36[/TD]
[TD="class: xl67, align: right"]83[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD="class: xl67, align: right"]63[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City37[/TD]
[TD="class: xl67, align: right"]27[/TD]
[TD="class: xl67, align: right"]75[/TD]
[TD="class: xl67, align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City38[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD="class: xl67, align: right"]64[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City39[/TD]
[TD="class: xl67, align: right"]73[/TD]
[TD="class: xl67, align: right"]69[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City40[/TD]
[TD="class: xl67, align: right"]32[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD="class: xl67, align: right"]28[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl65"]City2[/TD]
[TD="class: xl65, align: right"]54[/TD]
[TD="class: xl65, align: right"]85[/TD]
[TD="class: xl65, align: right"]19[/TD]
[TD][/TD]
[TD="colspan: 2"]City2 is at the top[/TD]
[/TR]
[TR]
[TD="class: xl67"]City1[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD="class: xl67, align: right"]30[/TD]
[TD="class: xl67, align: right"]32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City3[/TD]
[TD="class: xl67, align: right"]78[/TD]
[TD="class: xl67, align: right"]1[/TD]
[TD="class: xl67, align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City4[/TD]
[TD="class: xl67, align: right"]63[/TD]
[TD="class: xl67, align: right"]44[/TD]
[TD="class: xl67, align: right"]68[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City5[/TD]
[TD="class: xl67, align: right"]13[/TD]
[TD="class: xl67, align: right"]85[/TD]
[TD="class: xl67, align: right"]95[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City6[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD="class: xl67, align: right"]16[/TD]
[TD="class: xl67, align: right"]81[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City7[/TD]
[TD="class: xl67, align: right"]21[/TD]
[TD="class: xl67, align: right"]8[/TD]
[TD="class: xl67, align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City8[/TD]
[TD="class: xl67, align: right"]78[/TD]
[TD="class: xl67, align: right"]86[/TD]
[TD="class: xl67, align: right"]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City9[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD="class: xl67, align: right"]1[/TD]
[TD="class: xl67, align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City10[/TD]
[TD="class: xl67, align: right"]90[/TD]
[TD="class: xl67, align: right"]87[/TD]
[TD="class: xl67, align: right"]52[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City11[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD="class: xl67, align: right"]1[/TD]
[TD="class: xl67, align: right"]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City12[/TD]
[TD="class: xl67, align: right"]76[/TD]
[TD="class: xl67, align: right"]85[/TD]
[TD="class: xl67, align: right"]54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City13[/TD]
[TD="class: xl67, align: right"]65[/TD]
[TD="class: xl67, align: right"]28[/TD]
[TD="class: xl67, align: right"]78[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City14[/TD]
[TD="class: xl67, align: right"]51[/TD]
[TD="class: xl67, align: right"]54[/TD]
[TD="class: xl67, align: right"]72[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City15[/TD]
[TD="class: xl67, align: right"]58[/TD]
[TD="class: xl67, align: right"]50[/TD]
[TD="class: xl67, align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City16[/TD]
[TD="class: xl67, align: right"]21[/TD]
[TD="class: xl67, align: right"]72[/TD]
[TD="class: xl67, align: right"]85[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City17[/TD]
[TD="class: xl67, align: right"]81[/TD]
[TD="class: xl67, align: right"]62[/TD]
[TD="class: xl67, align: right"]58[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City18[/TD]
[TD="class: xl67, align: right"]14[/TD]
[TD="class: xl67, align: right"]30[/TD]
[TD="class: xl67, align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City19[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]8[/TD]
[TD="class: xl67, align: right"]10[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City20[/TD]
[TD="class: xl67, align: right"]41[/TD]
[TD="class: xl67, align: right"]4[/TD]
[TD="class: xl67, align: right"]19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City21[/TD]
[TD="class: xl67, align: right"]86[/TD]
[TD="class: xl67, align: right"]20[/TD]
[TD="class: xl67, align: right"]50[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City22[/TD]
[TD="class: xl67, align: right"]53[/TD]
[TD="class: xl67, align: right"]36[/TD]
[TD="class: xl67, align: right"]54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City23[/TD]
[TD="class: xl67, align: right"]92[/TD]
[TD="class: xl67, align: right"]100[/TD]
[TD="class: xl67, align: right"]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City24[/TD]
[TD="class: xl67, align: right"]20[/TD]
[TD="class: xl67, align: right"]85[/TD]
[TD="class: xl67, align: right"]71[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City25[/TD]
[TD="class: xl67, align: right"]12[/TD]
[TD="class: xl67, align: right"]97[/TD]
[TD="class: xl67, align: right"]69[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City26[/TD]
[TD="class: xl67, align: right"]28[/TD]
[TD="class: xl67, align: right"]3[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City27[/TD]
[TD="class: xl67, align: right"]28[/TD]
[TD="class: xl67, align: right"]68[/TD]
[TD="class: xl67, align: right"]36[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City28[/TD]
[TD="class: xl67, align: right"]62[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]47[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City29[/TD]
[TD="class: xl67, align: right"]39[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]28[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City30[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]51[/TD]
[TD="class: xl67, align: right"]41[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City31[/TD]
[TD="class: xl67, align: right"]45[/TD]
[TD="class: xl67, align: right"]17[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City32[/TD]
[TD="class: xl67, align: right"]97[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD="class: xl67, align: right"]97[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City33[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD="class: xl67, align: right"]31[/TD]
[TD="class: xl67, align: right"]72[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City34[/TD]
[TD="class: xl67, align: right"]18[/TD]
[TD="class: xl67, align: right"]67[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City35[/TD]
[TD="class: xl67, align: right"]59[/TD]
[TD="class: xl67, align: right"]78[/TD]
[TD="class: xl67, align: right"]92[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City36[/TD]
[TD="class: xl67, align: right"]73[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD="class: xl67, align: right"]80[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City37[/TD]
[TD="class: xl67, align: right"]74[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]85[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City38[/TD]
[TD="class: xl67, align: right"]30[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD="class: xl67, align: right"]33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City39[/TD]
[TD="class: xl67, align: right"]66[/TD]
[TD="class: xl67, align: right"]81[/TD]
[TD="class: xl67, align: right"]90[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City40[/TD]
[TD="class: xl67, align: right"]43[/TD]
[TD="class: xl67, align: right"]3[/TD]
[TD="class: xl67, align: right"]86[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"]City3[/TD]
[TD="class: xl64, align: right"]67[/TD]
[TD="class: xl64, align: right"]11[/TD]
[TD="class: xl64, align: right"]44[/TD]
[TD][/TD]
[TD="colspan: 2"]City3 is at the top[/TD]
[/TR]
[TR]
[TD="class: xl67"]City1[/TD]
[TD="class: xl67, align: right"]21[/TD]
[TD="class: xl67, align: right"]48[/TD]
[TD="class: xl67, align: right"]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City2[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD="class: xl67, align: right"]52[/TD]
[TD="class: xl67, align: right"]31[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City4[/TD]
[TD="class: xl67, align: right"]85[/TD]
[TD="class: xl67, align: right"]90[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City5[/TD]
[TD="class: xl67, align: right"]55[/TD]
[TD="class: xl67, align: right"]7[/TD]
[TD="class: xl67, align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City6[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD="class: xl67, align: right"]35[/TD]
[TD="class: xl67, align: right"]65[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City7[/TD]
[TD="class: xl67, align: right"]48[/TD]
[TD="class: xl67, align: right"]80[/TD]
[TD="class: xl67, align: right"]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City8[/TD]
[TD="class: xl67, align: right"]8[/TD]
[TD="class: xl67, align: right"]55[/TD]
[TD="class: xl67, align: right"]92[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City9[/TD]
[TD="class: xl67, align: right"]71[/TD]
[TD="class: xl67, align: right"]44[/TD]
[TD="class: xl67, align: right"]49[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City10[/TD]
[TD="class: xl67, align: right"]47[/TD]
[TD="class: xl67, align: right"]3[/TD]
[TD="class: xl67, align: right"]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City11[/TD]
[TD="class: xl67, align: right"]27[/TD]
[TD="class: xl67, align: right"]28[/TD]
[TD="class: xl67, align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City12[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD="class: xl67, align: right"]44[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City13[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD="class: xl67, align: right"]59[/TD]
[TD="class: xl67, align: right"]28[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City14[/TD]
[TD="class: xl67, align: right"]98[/TD]
[TD="class: xl67, align: right"]24[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City15[/TD]
[TD="class: xl67, align: right"]18[/TD]
[TD="class: xl67, align: right"]47[/TD]
[TD="class: xl67, align: right"]32[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City16[/TD]
[TD="class: xl67, align: right"]88[/TD]
[TD="class: xl67, align: right"]83[/TD]
[TD="class: xl67, align: right"]38[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City17[/TD]
[TD="class: xl67, align: right"]81[/TD]
[TD="class: xl67, align: right"]37[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City18[/TD]
[TD="class: xl67, align: right"]79[/TD]
[TD="class: xl67, align: right"]79[/TD]
[TD="class: xl67, align: right"]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City19[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD="class: xl67, align: right"]52[/TD]
[TD="class: xl67, align: right"]86[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City20[/TD]
[TD="class: xl67, align: right"]100[/TD]
[TD="class: xl67, align: right"]46[/TD]
[TD="class: xl67, align: right"]72[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City21[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD="class: xl67, align: right"]48[/TD]
[TD="class: xl67, align: right"]20[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City22[/TD]
[TD="class: xl67, align: right"]51[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD="class: xl67, align: right"]59[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City23[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD="class: xl67, align: right"]39[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City24[/TD]
[TD="class: xl67, align: right"]57[/TD]
[TD="class: xl67, align: right"]8[/TD]
[TD="class: xl67, align: right"]96[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City25[/TD]
[TD="class: xl67, align: right"]76[/TD]
[TD="class: xl67, align: right"]73[/TD]
[TD="class: xl67, align: right"]96[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City26[/TD]
[TD="class: xl67, align: right"]22[/TD]
[TD="class: xl67, align: right"]6[/TD]
[TD="class: xl67, align: right"]8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City27[/TD]
[TD="class: xl67, align: right"]15[/TD]
[TD="class: xl67, align: right"]100[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City28[/TD]
[TD="class: xl67, align: right"]72[/TD]
[TD="class: xl67, align: right"]62[/TD]
[TD="class: xl67, align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City29[/TD]
[TD="class: xl67, align: right"]56[/TD]
[TD="class: xl67, align: right"]24[/TD]
[TD="class: xl67, align: right"]79[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City30[/TD]
[TD="class: xl67, align: right"]96[/TD]
[TD="class: xl67, align: right"]35[/TD]
[TD="class: xl67, align: right"]95[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City31[/TD]
[TD="class: xl67, align: right"]31[/TD]
[TD="class: xl67, align: right"]37[/TD]
[TD="class: xl67, align: right"]17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City32[/TD]
[TD="class: xl67, align: right"]86[/TD]
[TD="class: xl67, align: right"]17[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City33[/TD]
[TD="class: xl67, align: right"]72[/TD]
[TD="class: xl67, align: right"]58[/TD]
[TD="class: xl67, align: right"]55[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City34[/TD]
[TD="class: xl67, align: right"]27[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD="class: xl67, align: right"]19[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City35[/TD]
[TD="class: xl67, align: right"]1[/TD]
[TD="class: xl67, align: right"]74[/TD]
[TD="class: xl67, align: right"]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City36[/TD]
[TD="class: xl67, align: right"]45[/TD]
[TD="class: xl67, align: right"]62[/TD]
[TD="class: xl67, align: right"]17[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City37[/TD]
[TD="class: xl67, align: right"]22[/TD]
[TD="class: xl67, align: right"]7[/TD]
[TD="class: xl67, align: right"]86[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City38[/TD]
[TD="class: xl67, align: right"]76[/TD]
[TD="class: xl67, align: right"]31[/TD]
[TD="class: xl67, align: right"]45[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City39[/TD]
[TD="class: xl67, align: right"]3[/TD]
[TD="class: xl67, align: right"]47[/TD]
[TD="class: xl67, align: right"]82[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City40[/TD]
[TD="class: xl67, align: right"]75[/TD]
[TD="class: xl67, align: right"]84[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl64"]City4[/TD]
[TD="class: xl64, align: right"]73[/TD]
[TD="class: xl64, align: right"]6[/TD]
[TD="class: xl64, align: right"]5[/TD]
[TD][/TD]
[TD="colspan: 2"]City4 is at the top[/TD]
[/TR]
[TR]
[TD="class: xl67"]City1[/TD]
[TD="class: xl67, align: right"]73[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD="class: xl67, align: right"]69[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City2[/TD]
[TD="class: xl67, align: right"]58[/TD]
[TD="class: xl67, align: right"]48[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City3[/TD]
[TD="class: xl67, align: right"]36[/TD]
[TD="class: xl67, align: right"]9[/TD]
[TD="class: xl67, align: right"]34[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City5[/TD]
[TD="class: xl67, align: right"]76[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD="class: xl67, align: right"]86[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City6[/TD]
[TD="class: xl67, align: right"]94[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD="class: xl67, align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City7[/TD]
[TD="class: xl67, align: right"]38[/TD]
[TD="class: xl67, align: right"]53[/TD]
[TD="class: xl67, align: right"]22[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City8[/TD]
[TD="class: xl67, align: right"]33[/TD]
[TD="class: xl67, align: right"]48[/TD]
[TD="class: xl67, align: right"]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City9[/TD]
[TD="class: xl67, align: right"]1[/TD]
[TD="class: xl67, align: right"]98[/TD]
[TD="class: xl67, align: right"]100[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City10[/TD]
[TD="class: xl67, align: right"]98[/TD]
[TD="class: xl67, align: right"]98[/TD]
[TD="class: xl67, align: right"]54[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City11[/TD]
[TD="class: xl67, align: right"]71[/TD]
[TD="class: xl67, align: right"]45[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City12[/TD]
[TD="class: xl67, align: right"]14[/TD]
[TD="class: xl67, align: right"]68[/TD]
[TD="class: xl67, align: right"]95[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City13[/TD]
[TD="class: xl67, align: right"]71[/TD]
[TD="class: xl67, align: right"]69[/TD]
[TD="class: xl67, align: right"]94[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City14[/TD]
[TD="class: xl67, align: right"]24[/TD]
[TD="class: xl67, align: right"]53[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City15[/TD]
[TD="class: xl67, align: right"]69[/TD]
[TD="class: xl67, align: right"]49[/TD]
[TD="class: xl67, align: right"]25[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City16[/TD]
[TD="class: xl67, align: right"]42[/TD]
[TD="class: xl67, align: right"]18[/TD]
[TD="class: xl67, align: right"]78[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City17[/TD]
[TD="class: xl67, align: right"]66[/TD]
[TD="class: xl67, align: right"]89[/TD]
[TD="class: xl67, align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City18[/TD]
[TD="class: xl67, align: right"]81[/TD]
[TD="class: xl67, align: right"]98[/TD]
[TD="class: xl67, align: right"]68[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City19[/TD]
[TD="class: xl67, align: right"]43[/TD]
[TD="class: xl67, align: right"]98[/TD]
[TD="class: xl67, align: right"]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City20[/TD]
[TD="class: xl67, align: right"]47[/TD]
[TD="class: xl67, align: right"]73[/TD]
[TD="class: xl67, align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City21[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD="class: xl67, align: right"]82[/TD]
[TD="class: xl67, align: right"]49[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City22[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD="class: xl67, align: right"]65[/TD]
[TD="class: xl67, align: right"]39[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City23[/TD]
[TD="class: xl67, align: right"]38[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City24[/TD]
[TD="class: xl67, align: right"]80[/TD]
[TD="class: xl67, align: right"]100[/TD]
[TD="class: xl67, align: right"]79[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City25[/TD]
[TD="class: xl67, align: right"]83[/TD]
[TD="class: xl67, align: right"]65[/TD]
[TD="class: xl67, align: right"]99[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City26[/TD]
[TD="class: xl67, align: right"]66[/TD]
[TD="class: xl67, align: right"]13[/TD]
[TD="class: xl67, align: right"]91[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City27[/TD]
[TD="class: xl67, align: right"]52[/TD]
[TD="class: xl67, align: right"]35[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City28[/TD]
[TD="class: xl67, align: right"]62[/TD]
[TD="class: xl67, align: right"]48[/TD]
[TD="class: xl67, align: right"]56[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City29[/TD]
[TD="class: xl67, align: right"]83[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD="class: xl67, align: right"]88[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City30[/TD]
[TD="class: xl67, align: right"]41[/TD]
[TD="class: xl67, align: right"]64[/TD]
[TD="class: xl67, align: right"]43[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City31[/TD]
[TD="class: xl67, align: right"]28[/TD]
[TD="class: xl67, align: right"]64[/TD]
[TD="class: xl67, align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City32[/TD]
[TD="class: xl67, align: right"]60[/TD]
[TD="class: xl67, align: right"]87[/TD]
[TD="class: xl67, align: right"]51[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City33[/TD]
[TD="class: xl67, align: right"]33[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD="class: xl67, align: right"]40[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City34[/TD]
[TD="class: xl67, align: right"]34[/TD]
[TD="class: xl67, align: right"]23[/TD]
[TD="class: xl67, align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City35[/TD]
[TD="class: xl67, align: right"]93[/TD]
[TD="class: xl67, align: right"]5[/TD]
[TD="class: xl67, align: right"]33[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City36[/TD]
[TD="class: xl67, align: right"]29[/TD]
[TD="class: xl67, align: right"]64[/TD]
[TD="class: xl67, align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City37[/TD]
[TD="class: xl67, align: right"]97[/TD]
[TD="class: xl67, align: right"]92[/TD]
[TD="class: xl67, align: right"]16[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City38[/TD]
[TD="class: xl67, align: right"]45[/TD]
[TD="class: xl67, align: right"]24[/TD]
[TD="class: xl67, align: right"]61[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City39[/TD]
[TD="class: xl67, align: right"]36[/TD]
[TD="class: xl67, align: right"]55[/TD]
[TD="class: xl67, align: right"]70[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl67"]City40[/TD]
[TD="class: xl67, align: right"]37[/TD]
[TD="class: xl67, align: right"]27[/TD]
[TD="class: xl67, align: right"]66[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]etc[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
You must log in or register to reply here.

Similar threads

W
  • Question Question
How to find N similar items?
Replies
9
Views
968
Fluff
Fluff

Forum statistics

Threads
1,223,904
Messages
6,175,295
Members
452,631
Latest member
a_potato

Share this page

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