sorting multiple blocks

3LeggedDog

Board Regular
Joined
Feb 11, 2006
Messages
149
Does anyone know of a way to sort multiple blocks of data, separated by blank rows, all by the same criterion? In this case, I'd like to be able to sort each block, as shown below, by column G, but the sorts have to be independent of each other...

Thanks,
3LD
pitching 1871-2005.xls
ABCDEFG
3381967willhni01WillhiteNick2NYNNL
3391967williro01WillisRon1SLNNL
3401967wilsodo01WilsonDon1HOUNL
3411967wiseri01WiseRick1PHINL
3421967woodeha01WoodeshickHal1SLNNL
3431967wynnebi02WynneBilly1NYNNL
3441967zachach02ZacharyChris1HOUNL
345
3461968adamsmi01AdamsonMike1BALAL
3471968akerja01AkerJack1OAKAL
3481968bahnsst01BahnsenStan1NYAAL
3491968bailest01BaileySteve1CLEAL
3501968baldwda01BaldwinDave1WS2AL
3511968barbest01BarberSteve1NYAAL
3521968beenefr01BeeneFred1BALAL
Sheet1
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Erdinç E. Karaçam

Board Regular
Joined
Sep 23, 2006
Messages
202
Hi,

For example: an sample table as below;

<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana>Gönderen XL Ver.:</font><font size=1 face=verdana> Office 2003 / </font><font size=1 color=red face=verdana>OS Ver.:</font><font size=1 face=verdana> Windows XP </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>A</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>B</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>C</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>D</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>E</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>F</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>G</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>willhni01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Willhite</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Nick</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>2</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>williro01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Willis</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Ron</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>SLN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>wilsodo01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Wilson</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Don</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>HOU</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>wiseri01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Wise</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Rick</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>PHI</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>5</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>woodeha01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Woodeshick</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Hal</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>SLN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>6</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>wynnebi02</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Wynne</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Billy</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>7</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>zachach02</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Zachary</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Chris</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>HOU</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>8</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>9</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>adamsmi01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Adamson</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Mike</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BAL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>10</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>akerja01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Aker</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Jack</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>OAK</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>11</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>bahnsst01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Bahnsen</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Stan</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYA</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>12</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>bailest01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Bailey</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Steve</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CLE</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>13</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>baldwda01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Baldwin</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Dave</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>WS2</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>14</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>barbest01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Barber</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Steve</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYA</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>15</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>beenefr01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Beene</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Fred</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BAL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>16</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>17</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>adamsmi01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Adamson</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Mike</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BAL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>18</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>akerja01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Aker</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Jack</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>OAK</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>19</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>bahnsst01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Bahnsen</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Stan</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYA</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>20</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>bailest01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Bailey</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Steve</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CLE</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>21</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>baldwda01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Baldwin</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Dave</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>WS2</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>22</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>barbest01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Barber</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Steve</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYA</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>23</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>beenefr01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Beene</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Fred</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BAL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>24</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana>XLtoHTML v1.1 / ExcelTürkiye - 2006©</font></td></tr></table>


Run this codes in Module1:

Code:
Sub SpecialSortMethod()
    Dim Counter As Long
    Dim TempCounter As Long
    Dim CeL As Range
    Dim CeLValue
    Set S1 = Sheets("Sheet1")
    Counter = S1.Range("G:G").SpecialCells(xlCellTypeLastCell).Row
    For Each CeL In S1.Range("G1:G" & Counter)
        If IsEmpty(CeL) = True Then Rows(CeL.Row).Delete Shift:=xlUp
        TempCounter = TempCounter + 1
    Next CeL
    Counter = Counter - TempCounter
    Range("A1:G" & TempCounter).Sort Key1:=Range("G1"), Order1:=xlAscending
    Counter = WorksheetFunction.CountA(S1.Range("G:G"))
    CeLValue = Cells(1, 7)
    For i = 1 To Counter
        If Cells(i, 7) <> CeLValue Then
            Rows(i).Insert Shift:=xlDown
            CeLValue = Cells(i + 1, 7)
            Counter = Counter + 1
        End If
    Next i
End Sub

After codes run:

<table border=1><tr><td align=left valign=center><font size=1 color=red face=verdana>Gönderen XL Ver.:</font><font size=1 face=verdana> Office 2003 / </font><font size=1 color=red face=verdana>OS Ver.:</font><font size=1 face=verdana> Windows XP </font></td></tr><tr valign=top><td><table border=0 bgcolor=d4d0c8 cellspacing=1 cellpadding=1 align=center><tr align=center valign=center bgcolor=white><td bgcolor=d4d0c8 align=center><font color=black size=2>+</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>A</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>B</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>C</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>D</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>E</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>F</font></td><td bgcolor=d4d0c8 width=60><font color=black size=1 face=verdana>G</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>1</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>adamsmi01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Adamson</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Mike</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BAL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>2</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>akerja01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Aker</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Jack</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>OAK</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>3</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>bahnsst01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Bahnsen</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Stan</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYA</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>4</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>bailest01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Bailey</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Steve</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CLE</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>5</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>baldwda01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Baldwin</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Dave</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>WS2</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>6</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>barbest01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Barber</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Steve</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYA</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>7</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1968</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>beenefr01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Beene</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Fred</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BAL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>AL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>8</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>9</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>adamsmi01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Adamson</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Mike</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BAL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>10</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>akerja01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Aker</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Jack</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>OAK</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>11</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>bahnsst01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Bahnsen</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Stan</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYA</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>12</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>bailest01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Bailey</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Steve</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>CLE</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>13</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>baldwda01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Baldwin</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Dave</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>WS2</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>14</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>barbest01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Barber</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Steve</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYA</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>15</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1969</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>beenefr01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Beene</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Fred</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>BAL</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>EK</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>16</font></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td><td bgcolor=white></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>17</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>willhni01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Willhite</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Nick</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>2</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>18</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>williro01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Willis</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Ron</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>SLN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>19</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>wilsodo01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Wilson</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Don</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>HOU</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>20</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>wiseri01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Wise</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Rick</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>PHI</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>21</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>woodeha01</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Woodeshick</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Hal</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>SLN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>22</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>wynnebi02</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Wynne</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Billy</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NYN</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr><tr align=left bgcolor=white height=20><td align=center valign=center bgcolor=d4d0c8 width=10><font color=black size=1 face=verdana>23</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1967</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>zachach02</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Zachary</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Chris</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>HOU</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>NL</font></td></tr></table></td></tr><tr><td bgcolor=f0f8ff align=center><font color=black size=1 face=verdana>XLtoHTML v1.1 / ExcelTürkiye - 2006©</font></td></tr></table>

Ok?
 

Forum statistics

Threads
1,136,995
Messages
5,679,037
Members
419,801
Latest member
spinjector

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
Top