picking from a list based on last date

[xcdave]

I have a list with 3 columns as shown below:

Book3
	A	B	C	D
1	Company Name	Date	Number of members
2	A	07/01/2006	48,765
3	A	07/01/2006	48,765
4	A	08/01/2006	48,774
5	A	08/01/2006	48,774
6	A	09/01/2006	148,906
7	A	09/01/2006	148,906
8	B	07/01/2006	151,623
9	B	08/01/2006	151,631
10	B	09/01/2006	151,648
11	C	07/01/2006	13,568
12	D	07/01/2006	10,217
13	D	08/01/2006	10,366
14	D	09/01/2006	10,490
15	E	07/01/2006	21,806
16	E	08/01/2006	21,920
17	E	09/01/2006	22,114
18	F	06/01/2006	10,092
19	F	07/01/2006	10,252
20	F	08/01/2006	10,835
Sheet1 (2)

I would like to filter this list so that for each company (column A) only the row with the last date is showing.

For example, 9/1/06 is the last date for company A, while for company C there is only one date, so it would be the only one showing.

I'm stuck - anyone have any ideas?

(I highlighted the rows in yellow manually to show which rows I want after being filtered)

 

[Aladin Akyurek]

Are you saying that you want to apply AutoFilter the results of which would show the yellow records?

 

[xcdave]

No - I just added the yellow to the list in order to highlight which records I want filtered (only one row per company, with only the entry with the latest date showing.)

So basically the table above would look like this when finished:

Book3
	A	B	C	D
1	Name	Date	Number of members	Same as one above?
2	A	09/01/2006	148,906	1
3	B	09/01/2006	151,648	1
4	C	07/01/2006	13,568	1
5	D	09/01/2006	10,490	1
6	E	09/01/2006	22,114	1
7	F	08/01/2006	10,835	1
Sheet1

I don't think I necessarily need to use autofilter if I can figure out another way to filter the list.

 

[Aladin Akyurek]

No - I just added the yellow to the list in order to highlight which records I want filtered (only one row per company, with only the entry with the latest date showing.)

...

I don't think I necessarily need to use autofilter if I can figure out another way to filter the list.

Book4
	A	B	C	D	E	F	G	H
1						6
2	Company Name	Date	Number of members	0		Company Name	Date	Number of members
3	A	7/1/2006	48,765	1		A	9/1/2006	148906
4	A	7/1/2006	48,765			B	9/1/2006	151648
5	A	8/1/2006	48,774			C	7/1/2006	13568
6	A	8/1/2006	48,774			D	9/1/2006	10490
7	A	9/1/2006	148,906			E	9/1/2006	22114
8	A	9/1/2006	148,906			F	8/1/2006	10835
9	B	7/1/2006	151,623	2
10	B	8/1/2006	151,631
11	B	9/1/2006	151,648
12	C	7/1/2006	13,568	3
13	D	7/1/2006	10,217	4
14	D	8/1/2006	10,366
15	D	9/1/2006	10,490
16	E	7/1/2006	21,806	5
17	E	8/1/2006	21,920
18	E	9/1/2006	22,114
19	F	6/1/2006	10,092	6
20	F	7/1/2006	10,252
21	F	8/1/2006	10,835
Sheet1

D2 must house a 0.

D3, copied down:

=IF(ISNUMBER(MATCH(A3,$A$2:A2,0)),"",LOOKUP(9.99999999999999E+307,$D$2:D2)+1)

F1:

=LOOKUP(9.99999999999999E+307,D2:D21)

F3, copied down:

=IF(ROWS($F$3:F3)<=$F$1,LOOKUP(ROWS($F$3:F3),$D$3:$D$21,$A$3:$A$21),"")

G3:

=IF(F3<>"",MAX(IF($A$3:$A$21=F3,$B$3:$B$21)),"")

which is confirmed with control+shift+enter (not with enter) and copied down.

H3:

=IF(F3<>"",INDEX($C$3:$C$21,MATCH(1,IF($A$3:$A$21=F3,IF($B$3:$B$21=G3,1)),0)),"")

which is confirmed with control+shift+enter (not with enter) and copied down.

 

[Erdinç E. Karaçam]

Hi everyone,

This is an alternative solution from me.

For example: our table like this:


<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 XP / </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><font size=1 color=black face=verdana>Company Name</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Date</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Number of members</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Company Name</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Date</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Number of members</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><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>48765</font></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>3</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>48765</font></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>4</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>48774</font></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>5</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>48774</font></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>6</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>148906</font></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>7</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>A</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>148906</font></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>8</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>B</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>151623</font></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><font size=1 color=black face=verdana>B</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>151631</font></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>10</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>B</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>151648</font></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>11</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>C</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>13568</font></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>12</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>D</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10217</font></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>13</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>D</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10366</font></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>14</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>D</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>1049</font></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>15</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>E</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>21806</font></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>16</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>E</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>2192</font></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=#FFFF99 nowrap=true><font size=1 color=black face=verdana>E</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>22114</font></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>18</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>F</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/6/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10092</font></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>19</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>F</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10252</font></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>20</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>F</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>10835</font></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>



And codes:

Sub Filter()
    Dim CeL As Range
    Dim i As Integer
        CurrentCondition = [A2]
        i = 1
            For Each CeL In Range("A2:A" & Range("A:A").SpecialCells(xlCellTypeLastCell).Row + 1)
                If CeL <> CurrentCondition Then
                    Cells(i + 1, 5) = CeL.Offset(-1, 0)
                    Cells(i + 1, 6) = CeL.Offset(-1, 1)
                    Cells(i + 1, 7) = CeL.Offset(-1, 2)
                    CurrentCondition = CeL
                    i = i + 1
                End If
            Next CeL
End Sub

And the result of codes:

<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 XP / </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><font size=1 color=black face=verdana>Company Name</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Date</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Number of members</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Company Name</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Date</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>Number of members</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><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>48765</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>148906</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><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>48765</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>B</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>151648</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><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>48774</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>C</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>13568</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><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>48774</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>D</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>1049</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><font size=1 color=black face=verdana>A</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>148906</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>E</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>22114</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=#FFFF99 nowrap=true><font size=1 color=black face=verdana>A</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>148906</font></td><td bgcolor=white></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>F</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10835</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 nowrap=true><font size=1 color=black face=verdana>B</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>151623</font></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><font size=1 color=black face=verdana>B</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>151631</font></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>10</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>B</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>151648</font></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>11</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>C</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>13568</font></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>12</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>D</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10217</font></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>13</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>D</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10366</font></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>14</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>D</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>1049</font></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>15</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>E</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>21806</font></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>16</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>E</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>2192</font></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=#FFFF99 nowrap=true><font size=1 color=black face=verdana>E</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/9/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>22114</font></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>18</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>F</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/6/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10092</font></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>19</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>F</font></td><td bgcolor=white nowrap=true><font size=1 color=black face=verdana>1/7/2006</font></td><td bgcolor=white nowrap=true align=right><font size=1 color=black face=verdana>10252</font></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>20</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>F</font></td><td bgcolor=#FFFF99 nowrap=true><font size=1 color=black face=verdana>1/8/2006</font></td><td bgcolor=#FFFF99 nowrap=true align=right><font size=1 color=black face=verdana>10835</font></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>