Help, need best formula to use for Total to show last date updated in previous columns

J

Jeremiah

New Member
Joined
Dec 5, 2010
Messages
5
PROBLEM: "Too many arguments!!!" :confused: IF/OR/AND/THEN Formula or is there a more appropriate formula I need?

Please help fix!!!!

=if(and(if(e2>d2,"out","break",c2>b2,"transfer","In")))

This is what I'm trying to do, kindly assist, very important, project depends on it, just can't get it right...

I have 5 teams deployed on different projects and I need the UPDATE Column to automatically indicate the status of the last date inputed on previous rows per team column.

For example:
Red 1 last updated their chart on 6/20/2010 when they took a break


<TABLE style="WIDTH: 313pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=417 border=0><COLGROUP><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" width=67><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" width=68><COL style="WIDTH: 60pt; mso-width-source: userset; mso-width-alt: 2925" width=80><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" span=2 width=68><COL style="WIDTH: 50pt" width=66><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #b8cce4" width=67 height=20>A1= Team</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #b8cce4" width=68>B1= In</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 60pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #b8cce4" width=80>C1=Transfer</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #b8cce4" width=68>D1=Break</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 51pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #b8cce4" width=68>E1=Out</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 50pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff66" width=66>F1=Status</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>RED 1</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">2/1/2010</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">3/15/2010</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">6/20/2010</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff66">Break</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>BLUE 2</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">6/5/2010</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff66"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>GREEN 3</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">1/15/2010</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">4/20/2010</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff66"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>YELLOW 4</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">2/1/2010</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">6/5/2010</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">7/15/2010</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">9/30/2010</TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff66"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20>PINK 5</TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">1/4/2010</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl67 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent">8/20/2010</TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff66"> </TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" height=20> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: #ffff66"> </TD></TR></TBODY></TABLE>
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
Will the dates always be in ascending order from left to right?

If so, try (in F2 filled down):

=IF(SUM(B2:E2),LOOKUP(9.99999999999999E+307,B2:E2,B$1:E$1),"")

If not, try:

=IF(SUM(B2:E2),LOOKUP(2,1/(B2:E2=MAX(B2:E2)),B$1:E$1),"")

which will take the right-most status in the case of a tie.
 
Upvote 0
Excel Workbook
ABCDEF
1A1= TeamB1= InC1=TransferD1=BreakE1=OutF1=Status
2RED 12/1/20103/15/20106/20/2010Break
3BLUE 26/5/2010In
4GREEN 31/15/20104/20/2010Transfer
5YELLOW 42/1/20106/5/20107/15/20109/30/2010Out
6PINK 51/4/20108/20/2010Break
...
Cell Formulas
RangeFormula
F2=CHOOSE(MATCH(MAX(B2:E2),B2:E2,0),"In","Transfer","Break","Out")
F3=CHOOSE(MATCH(MAX(B3:E3),B3:E3,0),"In","Transfer","Break","Out")
F4=CHOOSE(MATCH(MAX(B4:E4),B4:E4,0),"In","Transfer","Break","Out")
F5=CHOOSE(MATCH(MAX(B5:E5),B5:E5,0),"In","Transfer","Break","Out")
F6=CHOOSE(MATCH(MAX(B6:E6),B6:E6,0),"In","Transfer","Break","Out")
 
Upvote 0
Jeremiah,

Welcome to the MrExcel forum.


Excel Workbook
ABCDEF
1TeamInTransferBreakOutStatus
2RED 12/1/20103/15/20106/20/2010Break
3BLUE 26/5/2010In
4GREEN 31/15/20104/20/2010Transfer
5YELLOW 42/1/20106/5/20107/15/20109/30/2010Out
6PINK 51/4/20108/20/2010Break
7
Sheet1




The formula in cell F2 copied down:

=IF(SUM($B2:$E2),LOOKUP(2,1/(($B2:$E2)*($B2:$E2>0)),$B$1:$E$1),"")
 
Upvote 0
Hello everyone!
Thank you so much for all your help!!!!!!!

There's no words to describe how grateful I am! Thanks again!
 
Upvote 0
I got another hiccup... How can I modify this formula to recognize empty columns and still provide status like below?

=IF(SUM($B2:$E2),LOOKUP(2,1/(($B2:$E2)*($B2:$E2>0)),$B$1:$E$1),"")


Sheet1

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 81px"><COL style="WIDTH: 87px"><COL style="WIDTH: 94px"><COL style="WIDTH: 87px"><COL style="WIDTH: 87px"><COL style="WIDTH: 81px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">1</TD><TD style="FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ccccff">Team</TD><TD style="FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ccccff">In</TD><TD style="FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ccccff">Transfer</TD><TD style="FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ccccff">Break</TD><TD style="FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ccccff">Out</TD><TD style="FONT-WEIGHT: bold; COLOR: #ff0000; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffff99">Status</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">2</TD><TD style="FONT-FAMILY: Calibri">RED 1</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right">1/1/2010</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right"></TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right">6/20/2010</TD><TD style="FONT-FAMILY: Verdana"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ff0000; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffff99">Break</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">3</TD><TD style="FONT-FAMILY: Calibri">BLUE 2</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right"></TD><TD style="FONT-FAMILY: Verdana"> </TD><TD style="FONT-FAMILY: Verdana"> </TD><TD style="FONT-FAMILY: Verdana"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ff0000; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffff99">In</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">4</TD><TD style="FONT-FAMILY: Calibri">GREEN 3</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right">1/15/2010</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right">4/20/2010</TD><TD style="FONT-FAMILY: Verdana"> </TD><TD style="FONT-FAMILY: Verdana"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ff0000; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffff99">Transfer</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">5</TD><TD style="FONT-FAMILY: Calibri">YELLOW 4</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right">2/1/2010</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right">6/5/2010</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right">7/15/2010</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right">9/30/2010</TD><TD style="FONT-WEIGHT: bold; COLOR: #ff0000; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffff99">Out</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">6</TD><TD style="FONT-FAMILY: Calibri">PINK 5</TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right">1/4/2010</TD><TD style="FONT-FAMILY: Verdana"> </TD><TD style="FONT-FAMILY: Calibri; TEXT-ALIGN: right"></TD><TD style="FONT-FAMILY: Verdana"> </TD><TD style="FONT-WEIGHT: bold; COLOR: #ff0000; FONT-FAMILY: Calibri; BACKGROUND-COLOR: #ffff99">In</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">7</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>F2</TD><TD>?????</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<!-- / message --><!-- sig -->
__________________
 
Upvote 0
Jeremiah said:
I got another hiccup... How can I modify this formula to recognize empty columns ..
Click to expand...
I presume you mean empty rows? Try this.

Excel Workbook
ABCDEF
1TeamInTransferBreakOutStatus
2RED 11/10/201020/06/2010Break
3BLUE 2In
4GREEN 315/01/201020/04/2010Transfer
5YELLOW 41/02/20105/06/201015/07/201030/09/2010Out
6PINK 54/01/2010In
Sheet9
 
Upvote 0
Actually, if you are using Excel 2007+ then you could try:

=IFERROR(LOOKUP(9.99999999999999E+307,B2:E2,B$1:E$1),$B$1)
 
Upvote 0
Hi Peter,

I tried =IFERROR(LOOKUP(9.99999999999999E+307,B2:E2,B$1:E$1),$B$1)

but didn't work.... did I do it wrong?

This is what I got...
<TABLE style="WIDTH: 457pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=608 border=0><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 78pt; mso-width-source: userset; mso-width-alt: 3803" width=104><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 3949" width=108><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4461" width=122><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #cacaca" width=64 height=20>

</TD><TD class=xl69 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #cacaca" width=64>A</TD><TD class=xl69 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: black; WIDTH: 78pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #cacaca" width=104>B</TD><TD class=xl69 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: black; WIDTH: 81pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #cacaca" width=108>C</TD><TD class=xl69 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: black; WIDTH: 62pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #cacaca" width=82>D</TD><TD class=xl69 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: black; WIDTH: 92pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #cacaca" width=122>E</TD><TD class=xl74 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #cacaca" width=64>F</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl76 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #cacaca" align=right width=64 height=20>1</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>Team</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 78pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=104>In</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 81pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=108>Transfer</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 62pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=82>Break</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 92pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=122>Out</TD><TD class=xl75 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>Status</TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD class=xl70 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: #cacaca" width=64 height=35>2</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>RED 1</TD><TD class=xl67 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 78pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=104>1/10/2010</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 81pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=108> </TD><TD class=xl66 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 62pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=82>20/06/2010</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 92pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=122> </TD><TD class=xl75 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>A</TD></TR><TR style="HEIGHT: 15pt" height=20><TD class=xl70 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 15pt; BACKGROUND-COLOR: #cacaca" width=64 height=20>3</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>BLUE 2</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 78pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=104> </TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 81pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=108> </TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 62pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=82> </TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 92pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=122> </TD><TD class=xl75 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>B</TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD class=xl70 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: #cacaca" width=64 height=35>4</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>GREEN 3</TD><TD class=xl66 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 78pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=104>15/01/2010</TD><TD class=xl66 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 81pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=108>20/04/2010</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 62pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=82> </TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 92pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=122> </TD><TD class=xl75 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>A</TD></TR><TR style="HEIGHT: 26.25pt" height=35><TD class=xl70 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; HEIGHT: 26.25pt; BACKGROUND-COLOR: #cacaca" width=64 height=35>5</TD><TD class=xl65 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>YELLOW 4</TD><TD class=xl67 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 78pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=104>1/2/2010</TD><TD class=xl67 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 81pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=108>5/6/2010</TD><TD class=xl66 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 62pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=82>15/07/2010</TD><TD class=xl66 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 92pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=122>30/09/2010</TD><TD class=xl75 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>A</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl71 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #cacaca" width=64 height=21>6</TD><TD class=xl72 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=64>PINK 5</TD><TD class=xl73 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 78pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=104>4/1/2010</TD><TD class=xl72 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 81pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=108> </TD><TD class=xl72 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 62pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=82> </TD><TD class=xl72 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 92pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=122> </TD><TD class=xl75 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: black; BORDER-LEFT: black; WIDTH: 48pt; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: white" width=64>C</TD></TR></TBODY></TABLE>
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question
VBA - Automatically Break the Line in HTML format.
Replies
7
Views
1K
Attrazion
A
G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
854
gvsumich
G
E
  • Question
VBA for Web Scraping help
Replies
0
Views
607
epactheactor
E
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
R
  • Question
Random
Replies
1
Views
454
Fluff
Fluff

Forum statistics

Threads
1,215,529
Messages
6,125,344
Members
449,219
Latest member
Smiqer

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top