IF AND based on condition of another cell

D

Delta729

New Member
Joined
Dec 24, 2010
Messages
36
I'm attempting to create an IF AND Statement which would let me know if there is a duplicate Time Type "SB" for a given name and date. The formula I have right now is not working and any help would be greatly appreciated.

=IF(P3="SB",IF(AND(N3=N2,O3=O2),"Duplicate","OK"))

<TABLE style="WIDTH: 422pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=563 border=0 x:str><COLGROUP><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 6802" width=186><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4498" width=123><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" span=2 width=67><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><TBODY><TR style="HEIGHT: 32.25pt; mso-height-source: userset" height=43><TD class=xl26 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 32.25pt; BACKGROUND-COLOR: #003366" width=186 height=43>Date Worked</TD><TD class=xl26 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #003366" width=123>Name</TD><TD class=xl26 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #003366" width=35>Time Type</TD><TD class=xl26 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #003366" width=67>Gross Price</TD><TD class=xl26 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #003366" width=67>Net Value</TD><TD class=xl27 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff; WIDTH: 64pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffcc99" width=85>Single
SB Verification</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl31 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=186 height=18 x:num="40181">Sunday, January 03, 2010</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=123>Bill Soderquist</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>NT</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="111.76">$111.76</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="223.52">$223.52</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white"> </TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl30 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ffff99" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl29 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=123>Acosta, Charles</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>IN</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="81.05">$81.05</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="162.1">$162.10</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(C3="SB",IF(AND(A3=A2,B3=B2),"Duplicate","OK"))' x:bool="FALSE">FALSE</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl30 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ffff99" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl29 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=123>Acosta, Charles</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>ML</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="15">$15.00</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="30">$30.00</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(AND(A4=A3,B4=B3),"Duplicate","OK")'>Duplicate</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl30 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ffff99" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl29 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=123>Acosta, Charles</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>PT</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="162.09">$162.09</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="1458.81">$1,458.81</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(AND(A5=A4,B5=B4),"Duplicate","OK")'>Duplicate</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl30 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ffff99" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl29 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=123>Acosta, Charles</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>PT</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="162.09">$162.09</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="1053.59">$1,053.59</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(AND(A6=A5,B6=B5),"Duplicate","OK")'>Duplicate</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl30 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ffff99" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl29 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=123>Acosta, Charles</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>SB</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="50">$50.00</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="50">$50.00</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(AND(A7=A6,B7=B6),"Duplicate","OK")'>Duplicate</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl31 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=123>Armenta, Robert</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>NT</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="93.16">$93.16</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="745.28">$745.28</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(AND(A8=A7,B8=B7),"Duplicate","OK")'>OK</TD></TR></TBODY></TABLE>

Date Worked = column N and no missing columns.

Any help would be greatly appreaciated.
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
I'm not following you? Using your formula I get
Excel Workbook
NOPQRST
1Date WorkedNameTime TypeGross PriceNet ValueSingle
2SB Verification
3Sunday, January 03, 2010Bill SoderquistNT$111.76$223.52FALSE
4Monday, November 01, 2010Acosta, CharlesIN$81.05$162.10FALSEFALSE
5Monday, November 01, 2010Acosta, CharlesML$15.00$30.00DuplicateFALSE
6Monday, November 01, 2010Acosta, CharlesPT$162.09$1,458.81DuplicateFALSE
7Monday, November 01, 2010Acosta, CharlesPT$162.09$1,053.59DuplicateFALSE
8Monday, November 01, 2010Acosta, CharlesSB$50.00$50.00DuplicateDuplicate
9Monday, November 01, 2010Armenta, RobertNT$93.16$745.28OKFALSE
Sheet1
Excel 2003
Cell Formulas
RangeFormula
T3=IF(P3="SB",IF(AND(N3=N2,O3=O2),"Duplicate","OK"))
T4=IF(P4="SB",IF(AND(N4=N3,O4=O3),"Duplicate","OK"))
T5=IF(P5="SB",IF(AND(N5=N4,O5=O4),"Duplicate","OK"))
T6=IF(P6="SB",IF(AND(N6=N5,O6=O5),"Duplicate","OK"))
T7=IF(P7="SB",IF(AND(N7=N6,O7=O6),"Duplicate","OK"))
T8=IF(P8="SB",IF(AND(N8=N7,O8=O7),"Duplicate","OK"))
T9=IF(P9="SB",IF(AND(N9=N8,O9=O8),"Duplicate","OK"))
 
Upvote 0
Sorry, I forgot to copy the formula down to the data I had copied. Your's is what I'm getting as well.
<TABLE style="WIDTH: 422pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=563 border=0 x:str><COLGROUP><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 6802" width=186><COL style="WIDTH: 92pt; mso-width-source: userset; mso-width-alt: 4498" width=123><COL style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1280" width=35><COL style="WIDTH: 50pt; mso-width-source: userset; mso-width-alt: 2450" span=2 width=67><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><TBODY><TR style="HEIGHT: 32.25pt; mso-height-source: userset" height=43><TD class=xl26 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 32.25pt; BACKGROUND-COLOR: #003366" width=186 height=43>Date Worked</TD><TD class=xl26 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #003366" width=123>Name</TD><TD class=xl26 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #003366" width=35>Time Type</TD><TD class=xl26 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #003366" width=67>Gross Price</TD><TD class=xl26 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #003366" width=67>Net Value</TD><TD class=xl27 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 0.5pt solid; BORDER-LEFT: #ccccff; WIDTH: 64pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffcc99" width=85>Single
SB Verification</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl31 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=186 height=18 x:num="40181">Sunday, January 03, 2010</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=123>Bill Soderquist</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>NT</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="111.76">$111.76</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="223.52">$223.52</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white"> </TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl30 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ffff99" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl29 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=123>Acosta, Charles</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>IN</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="81.05">$81.05</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="162.1">$162.10</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(C3="SB",IF(AND(A3=A2,B3=B2),"Duplicate","OK"))' x:bool="FALSE">FALSE</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl30 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ffff99" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl29 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=123>Acosta, Charles</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>ML</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="15">$15.00</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="30">$30.00</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(C4="SB",IF(AND(A4=A3,B4=B3),"Duplicate","OK"))' x:bool="FALSE">FALSE</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl30 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ffff99" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl29 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=123>Acosta, Charles</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>PT</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="162.09">$162.09</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="1458.81">$1,458.81</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(C5="SB",IF(AND(A5=A4,B5=B4),"Duplicate","OK"))' x:bool="FALSE">FALSE</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl30 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ffff99" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl29 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=123>Acosta, Charles</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>PT</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="162.09">$162.09</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="1053.59">$1,053.59</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(C6="SB",IF(AND(A6=A5,B6=B5),"Duplicate","OK"))' x:bool="FALSE">FALSE</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl30 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: #ffff99" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl29 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=123>Acosta, Charles</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>SB</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="50">$50.00</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="50">$50.00</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(C7="SB",IF(AND(A7=A6,B7=B6),"Duplicate","OK"))'>Duplicate</TD></TR><TR style="HEIGHT: 13.5pt; mso-height-source: userset" height=18><TD class=xl31 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 0.5pt solid; WIDTH: 140pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 13.5pt; BACKGROUND-COLOR: white" width=186 height=18 x:num="40483">Monday, November 01, 2010</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 92pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=123>Armenta, Robert</TD><TD class=xl24 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 26pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=35>NT</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="93.16">$93.16</TD><TD class=xl25 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff; WIDTH: 50pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=67 x:num="745.28">$745.28</TD><TD class=xl28 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: white" x:fmla='=IF(C8="SB",IF(AND(A8=A7,B8=B7),"Duplicate","OK"))' x:bool="FALSE">FALSE</TD></TR></TBODY></TABLE>

What I need to have happen is if the "Date Worked" and "Name" are the same and if the Time Type appears more than once for the given Date and Name, then it would show as a duplicate. If there isn't a duplicate for the Date worked and name, it would then show as OK.

Sorry, hope that makes more sence.
 
Upvote 0
Dear Delta,

Try this formula ....

=IF(AND(N3=N2,O3=O2),IF(AND(P3=P2),"Duplicate","OK"),"OK")

if not work, please forward your desired result on the column U.

Thanks & Regards,

Murali
 
Upvote 0
Still not working.


Name Quantity Time Type Gross Price Net Value "Single
SB Verification"
Bill Soderquist 2 NT $111.76 $223.52
Acosta, Charles 2 IN $81.05 $162.10 OK ok
Acosta, Charles 2 ML $15.00 $30.00 Duplicate ok
Acosta, Charles 9 PT $162.09 $1,458.81 OK ok
Acosta, Charles 6.5 PT $162.09 $1,053.59 OK Duplicate
Acosta, Charles 1 SB $50.00 $50.00 OK ok
Armenta, Robert 8 NT $93.16 $745.28 OK ok
 
Upvote 0
Try this formula on Column S....

=IF(AND(N3=N2,O3=O2),IF(AND(P1=P2),"Duplicate","OK"),"OK")

Thanks & Regards,

Murali
<!-- / message -->
 
Upvote 0
Am getting this result.

Is this what u desired?

<TABLE style="WIDTH: 440pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=587 border=0><COLGROUP><COL style="WIDTH: 150pt; mso-width-source: userset; mso-width-alt: 7314" width=200><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl68 style="BORDER-RIGHT: #ccccff 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 150pt; BORDER-BOTTOM: #ccccff 1pt solid; HEIGHT: 54.75pt; BACKGROUND-COLOR: #003366" width=200 height=73 rowSpan=2>Date Worked

</TD><TD class=xl69 style="BORDER-RIGHT: #ccccff 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 87pt; BORDER-BOTTOM: #ccccff 1pt solid; BACKGROUND-COLOR: #003366" width=116 rowSpan=2>Name</TD><TD class=xl69 style="BORDER-RIGHT: #ccccff 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 1pt solid; BACKGROUND-COLOR: #003366" width=64 rowSpan=2>Time Type</TD><TD class=xl69 style="BORDER-RIGHT: #ccccff 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 1pt solid; BACKGROUND-COLOR: #003366" width=64 rowSpan=2>Gross Price</TD><TD class=xl69 style="BORDER-RIGHT: #ccccff 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 59pt; BORDER-BOTTOM: #ccccff 1pt solid; BACKGROUND-COLOR: #003366" width=79 rowSpan=2>Net Value</TD><TD class=xl76 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #3867a6 1pt solid; BORDER-LEFT: #ccccff; WIDTH: 48pt; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: #ffcc99" width=64>Single</TD></TR><TR style="HEIGHT: 39.75pt" height=53><TD class=xl77 style="BORDER-RIGHT: #3867a6 1pt solid; BORDER-TOP: #ece9d8; BORDER-LEFT: #ccccff; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 39.75pt; BACKGROUND-COLOR: #ffcc99" width=64 height=53>SB Verification</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl71 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 150pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" width=200 height=21 u1:num="40181">Sunday, January 03, 2010</TD><TD class=xl64 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 87pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=116>Bill Soderquist</TD><TD class=xl64 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=64>NT</TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=64 u1:num="111.76">$111.76 </TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 59pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=79 u1:num="223.52">$223.52 </TD><TD class=xl63 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black 0.5pt solid; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #efefef">OK</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl72 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 150pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #ffff99" width=200 height=21 u1:num="40483">Monday, November 01, 2010</TD><TD class=xl66 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 87pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=116>Acosta, Charles</TD><TD class=xl64 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=64>IN</TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=64 u1:num="81.05">$81.05 </TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 59pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=79 u1:num="162.1">$162.10 </TD><TD class=xl63 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #efefef">OK</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl72 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 150pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #ffff99" width=200 height=21 u1:num="40483">Monday, November 01, 2010</TD><TD class=xl66 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 87pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=116>Acosta, Charles</TD><TD class=xl64 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=64>ML</TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=64 u1:num="15">$15.00 </TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 59pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=79 u1:num="30">$30.00 </TD><TD class=xl63 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #efefef">OK</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl72 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 150pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #ffff99" width=200 height=21 u1:num="40483">Monday, November 01, 2010</TD><TD class=xl66 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 87pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=116>Acosta, Charles</TD><TD class=xl64 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=64>PT</TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=64 u1:num="162.09">$162.09 </TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 59pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=79 u1:num="1458.81">$1,458.81 </TD><TD class=xl63 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #efefef">OK</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl72 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 150pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #ffff99" width=200 height=21 u1:num="40483">Monday, November 01, 2010</TD><TD class=xl66 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 87pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=116>Acosta, Charles</TD><TD class=xl64 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=64>PT</TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=64 u1:num="162.09">$162.09 </TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 59pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=79 u1:num="1053.59">$1,053.59 </TD><TD class=xl63 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #efefef">Duplicate</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl72 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 150pt; BORDER-BOTTOM: #ccccff 0.5pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: #ffff99" width=200 height=21 u1:num="40483">Monday, November 01, 2010</TD><TD class=xl66 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 87pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: #ffff99" width=116>Acosta, Charles</TD><TD class=xl64 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" width=64>SB</TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=64 u1:num="50">$50.00 </TD><TD class=xl65 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 59pt; BORDER-BOTTOM: #ccccff 0.5pt solid; BACKGROUND-COLOR: white" align=right width=79 u1:num="50">$50.00 </TD><TD class=xl63 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #efefef">OK</TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD class=xl73 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #3867a6 1pt solid; WIDTH: 150pt; BORDER-BOTTOM: #3867a6 1pt solid; HEIGHT: 15.75pt; BACKGROUND-COLOR: white" width=200 height=21 u1:num="40483">Monday, November 01, 2010</TD><TD class=xl74 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 87pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=116>Armenta, Robert</TD><TD class=xl74 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" width=64>NT</TD><TD class=xl75 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 48pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" align=right width=64 u1:num="93.16">$93.16 </TD><TD class=xl75 style="BORDER-RIGHT: #ccccff 0.5pt solid; BORDER-TOP: #ccccff 1pt solid; BORDER-LEFT: #ccccff 1pt solid; WIDTH: 59pt; BORDER-BOTTOM: #3867a6 1pt solid; BACKGROUND-COLOR: white" align=right width=79 u1:num="745.28">$745.28 </TD><TD class=xl63 style="BORDER-RIGHT: black 0.5pt solid; BORDER-TOP: black; BORDER-LEFT: black 0.5pt solid; BORDER-BOTTOM: black 0.5pt solid; BACKGROUND-COLOR: #efefef">OK</TD></TR></TBODY></TABLE>

Thanks & Regards,

Murali
<!-- / message -->
 
Upvote 0
Yes, that's the results I'm looking for. However, when I put your last formula in my Excel spreadsheet, that's not what I got.
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
619
smozgur
smozgur
T
  • Question Question
Exporting Cell Range As PNG - Getting A White Border To The Bottom & Right - Why?
2
Replies
16
Views
175
jolivanes
jolivanes
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
E
  • Question Question
VBA code clean up
Replies
9
Views
574
mumps
mumps
G
  • Question Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
1K
gvsumich
G

Forum statistics

Threads
1,224,548
Messages
6,179,445
Members
452,915
Latest member
hannnahheileen

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