picking from a list based on last date

xcdave

Board Regular
Joined
Nov 11, 2004
Messages
61
I have a list with 3 columns as shown below:
Book3
ABCD
1Company NameDateNumber of members
2A07/01/200648,765
3A07/01/200648,765
4A08/01/200648,774
5A08/01/200648,774
6A09/01/2006148,906
7A09/01/2006148,906
8B07/01/2006151,623
9B08/01/2006151,631
10B09/01/2006151,648
11C07/01/200613,568
12D07/01/200610,217
13D08/01/200610,366
14D09/01/200610,490
15E07/01/200621,806
16E08/01/200621,920
17E09/01/200622,114
18F06/01/200610,092
19F07/01/200610,252
20F08/01/200610,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)
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
Are you saying that you want to apply AutoFilter the results of which would show the yellow records?
 

xcdave

Board Regular
Joined
Nov 11, 2004
Messages
61
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
ABCD
1NameDateNumber of membersSame as one above?
2A09/01/2006148,9061
3B09/01/2006151,6481
4C07/01/200613,5681
5D09/01/200610,4901
6E09/01/200622,1141
7F08/01/200610,8351
Sheet1


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

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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
ABCDEFGH
16
2Company NameDateNumber of members0Company NameDateNumber of members
3A7/1/200648,7651A9/1/2006148906
4A7/1/200648,765 B9/1/2006151648
5A8/1/200648,774 C7/1/200613568
6A8/1/200648,774 D9/1/200610490
7A9/1/2006148,906 E9/1/200622114
8A9/1/2006148,906 F8/1/200610835
9B7/1/2006151,6232  
10B8/1/2006151,631  
11B9/1/2006151,648  
12C7/1/200613,5683
13D7/1/200610,2174
14D8/1/200610,366 
15D9/1/200610,490 
16E7/1/200621,8065
17E8/1/200621,920 
18E9/1/200622,114 
19F6/1/200610,0926
20F7/1/200610,252 
21F8/1/200610,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

Board Regular
Joined
Sep 23, 2006
Messages
202
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:

Code:
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>
 

Forum statistics

Threads
1,136,517
Messages
5,676,319
Members
419,619
Latest member
jalme

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