If cells contains this, do this until...

T

tblackwell

New Member
Joined
Oct 24, 2018
Messages
28
Office Version
  1. 365
Platform
  1. Windows
Hi - Newbie here. Read the FAQs, rules and searched the forum and did not find an answer so created a new post. Bear with me.

Question: If cell's contains this do this until...
Hypothetical Example: Trying to write a formula to look for characters that begin with 6, then return the first four characters of that cell.
I got that but here is where I get stuck: If does not begin with 6, then use first four characters of cell that does begin with 6 UNTIL it finds a new number
Current formula where I get stuck: =IF(LEFT(C14,1)="6",LEFT(C14,4),C13)
System: Windows 10 Pro

CMNOPQRSTUVWX
Reference CellsMy FormulaWhat I Want
6001 24 Highway - 2192
L-FREE-CHIKNWFRYDRNK6001 24 Highway - 2192
L-FREE-SINGLE FRYDRKL-FREE-CHIKNWFRYDRNK
N-0200-OFF FULLSALADL-FREE-SINGLE FRYDRK
N-0200-OFFCOMBON-0200-OFF FULLSALAD
N-BOGO-3PC TENDERSN-0200-OFFCOMBO
N-BOGO-CHICKENN-BOGO-3PC TENDERS
N-BOGO-SINGLECHEESEN-BOGO-CHICKEN
N-DISC-2SGLCHZ CMBN-BOGO-SINGLECHEESE
N-DISC-2SPC CHK CMBN-DISC-2SGLCHZ CMB
N-DISC-DBL CHZ CMBN-DISC-2SPC CHK CMB
N-DISC-KM CHICKENN-DISC-DBL CHZ CMB
N-DISC-KM CHK TENDERN-DISC-KM CHICKEN
N-DISC-KM CHZBURGERN-DISC-KM CHK TENDER
N-DISC-KM HAMBURGERN-DISC-KM CHZBURGER
N-DISC-KM NUGGETN-DISC-KM HAMBURGER
N-DISC-KM WRAPSN-DISC-KM NUGGET
N-FREE-COOKIEN-DISC-KM WRAPS
N-FREE-JRFRSTYKEYTAGN-FREE-COOKIE
N-FREE-TNDRSW/FRYDRKN-FREE-JRFRSTYKEYTAG
6001 24 Highway - 2192 Quantity:
6002 40 Highway - 8246
L-FREE-CHIKNWFRYDRNK6002 40 Highway - 8246
L-FREE-SINGLE FRYDRKL-FREE-CHIKNWFRYDRNK
N-0200-OFF FULLSALADL-FREE-SINGLE FRYDRK
N-0200-OFFCOMBON-0200-OFF FULLSALAD
N-BOGO-3PC TENDERSN-0200-OFFCOMBO
N-BOGO-CHICKENN-BOGO-3PC TENDERS
N-BOGO-SINGLECHEESEN-BOGO-CHICKEN
N-DISC-2SGLCHZ CMBN-BOGO-SINGLECHEESE
N-DISC-2SPC CHK CMBN-DISC-2SGLCHZ CMB
N-DISC-DBL CHZ CMBN-DISC-2SPC CHK CMB
N-DISC-KM CHICKENN-DISC-DBL CHZ CMB
N-DISC-KM CHK TENDERN-DISC-KM CHICKEN
N-DISC-KM CHZBURGERN-DISC-KM CHK TENDER
N-DISC-KM HAMBURGERN-DISC-KM CHZBURGER
N-DISC-KM NUGGETN-DISC-KM HAMBURGER
N-DISC-KM WRAPSN-DISC-KM NUGGET
N-FREE-COOKIEN-DISC-KM WRAPS
N-FREE-JRFRSTYKEYTAGN-FREE-COOKIE
N-FREE-TNDRSW/FRYDRKN-FREE-JRFRSTYKEYTAG
6002 40 Highway - 8246 Quantity:
6003 State Ave - 2183
L-FREE-CHIKNWFRYDRNK6003 State Ave - 2183
L-FREE-SINGLE FRYDRKL-FREE-CHIKNWFRYDRNK

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]13[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]31[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]32[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]33[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]34[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]35[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]36[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]37[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]38[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]39[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]40[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]41[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]42[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]43[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]44[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]45[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]46[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]47[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]48[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]49[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]50[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]51[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]52[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]53[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]54[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]55[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]56[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]

[TD="align: center"]57[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]

[TD="align: center"]58[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]

</tbody>
ToFormat​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C14[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A10="",'[Promotion Detail_twb.xls]Sheet1'!B10,'[Promotion Detail_twb.xls]Sheet1'!A10)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C15[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A11="",'[Promotion Detail_twb.xls]Sheet1'!B11,'[Promotion Detail_twb.xls]Sheet1'!A11)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C16[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A12="",'[Promotion Detail_twb.xls]Sheet1'!B12,'[Promotion Detail_twb.xls]Sheet1'!A12)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C17[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A13="",'[Promotion Detail_twb.xls]Sheet1'!B13,'[Promotion Detail_twb.xls]Sheet1'!A13)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C18[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A14="",'[Promotion Detail_twb.xls]Sheet1'!B14,'[Promotion Detail_twb.xls]Sheet1'!A14)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C19[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A15="",'[Promotion Detail_twb.xls]Sheet1'!B15,'[Promotion Detail_twb.xls]Sheet1'!A15)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C20[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A16="",'[Promotion Detail_twb.xls]Sheet1'!B16,'[Promotion Detail_twb.xls]Sheet1'!A16)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C21[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A17="",'[Promotion Detail_twb.xls]Sheet1'!B17,'[Promotion Detail_twb.xls]Sheet1'!A17)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C22[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A18="",'[Promotion Detail_twb.xls]Sheet1'!B18,'[Promotion Detail_twb.xls]Sheet1'!A18)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C23[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A19="",'[Promotion Detail_twb.xls]Sheet1'!B19,'[Promotion Detail_twb.xls]Sheet1'!A19)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C24[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A20="",'[Promotion Detail_twb.xls]Sheet1'!B20,'[Promotion Detail_twb.xls]Sheet1'!A20)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C25[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A21="",'[Promotion Detail_twb.xls]Sheet1'!B21,'[Promotion Detail_twb.xls]Sheet1'!A21)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C26[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A22="",'[Promotion Detail_twb.xls]Sheet1'!B22,'[Promotion Detail_twb.xls]Sheet1'!A22)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C27[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A23="",'[Promotion Detail_twb.xls]Sheet1'!B23,'[Promotion Detail_twb.xls]Sheet1'!A23)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C28[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A24="",'[Promotion Detail_twb.xls]Sheet1'!B24,'[Promotion Detail_twb.xls]Sheet1'!A24)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C29[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A25="",'[Promotion Detail_twb.xls]Sheet1'!B25,'[Promotion Detail_twb.xls]Sheet1'!A25)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C30[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A26="",'[Promotion Detail_twb.xls]Sheet1'!B26,'[Promotion Detail_twb.xls]Sheet1'!A26)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C31[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A27="",'[Promotion Detail_twb.xls]Sheet1'!B27,'[Promotion Detail_twb.xls]Sheet1'!A27)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C32[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A28="",'[Promotion Detail_twb.xls]Sheet1'!B28,'[Promotion Detail_twb.xls]Sheet1'!A28)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C33[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A29="",'[Promotion Detail_twb.xls]Sheet1'!B29,'[Promotion Detail_twb.xls]Sheet1'!A29)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C34[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A30="",'[Promotion Detail_twb.xls]Sheet1'!B30,'[Promotion Detail_twb.xls]Sheet1'!A30)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C35[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A31="",'[Promotion Detail_twb.xls]Sheet1'!B31,'[Promotion Detail_twb.xls]Sheet1'!A31)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C36[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A32="",'[Promotion Detail_twb.xls]Sheet1'!B32,'[Promotion Detail_twb.xls]Sheet1'!A32)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C37[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A33="",'[Promotion Detail_twb.xls]Sheet1'!B33,'[Promotion Detail_twb.xls]Sheet1'!A33)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C38[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A34="",'[Promotion Detail_twb.xls]Sheet1'!B34,'[Promotion Detail_twb.xls]Sheet1'!A34)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C39[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A35="",'[Promotion Detail_twb.xls]Sheet1'!B35,'[Promotion Detail_twb.xls]Sheet1'!A35)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C40[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A36="",'[Promotion Detail_twb.xls]Sheet1'!B36,'[Promotion Detail_twb.xls]Sheet1'!A36)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C41[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A37="",'[Promotion Detail_twb.xls]Sheet1'!B37,'[Promotion Detail_twb.xls]Sheet1'!A37)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C42[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A38="",'[Promotion Detail_twb.xls]Sheet1'!B38,'[Promotion Detail_twb.xls]Sheet1'!A38)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C43[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A39="",'[Promotion Detail_twb.xls]Sheet1'!B39,'[Promotion Detail_twb.xls]Sheet1'!A39)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C44[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A40="",'[Promotion Detail_twb.xls]Sheet1'!B40,'[Promotion Detail_twb.xls]Sheet1'!A40)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C45[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A41="",'[Promotion Detail_twb.xls]Sheet1'!B41,'[Promotion Detail_twb.xls]Sheet1'!A41)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C46[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A42="",'[Promotion Detail_twb.xls]Sheet1'!B42,'[Promotion Detail_twb.xls]Sheet1'!A42)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C47[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A43="",'[Promotion Detail_twb.xls]Sheet1'!B43,'[Promotion Detail_twb.xls]Sheet1'!A43)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C48[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A44="",'[Promotion Detail_twb.xls]Sheet1'!B44,'[Promotion Detail_twb.xls]Sheet1'!A44)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C49[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A45="",'[Promotion Detail_twb.xls]Sheet1'!B45,'[Promotion Detail_twb.xls]Sheet1'!A45)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C50[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A46="",'[Promotion Detail_twb.xls]Sheet1'!B46,'[Promotion Detail_twb.xls]Sheet1'!A46)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C51[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A47="",'[Promotion Detail_twb.xls]Sheet1'!B47,'[Promotion Detail_twb.xls]Sheet1'!A47)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C52[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A48="",'[Promotion Detail_twb.xls]Sheet1'!B48,'[Promotion Detail_twb.xls]Sheet1'!A48)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C53[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A49="",'[Promotion Detail_twb.xls]Sheet1'!B49,'[Promotion Detail_twb.xls]Sheet1'!A49)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C54[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A50="",'[Promotion Detail_twb.xls]Sheet1'!B50,'[Promotion Detail_twb.xls]Sheet1'!A50)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C55[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A51="",'[Promotion Detail_twb.xls]Sheet1'!B51,'[Promotion Detail_twb.xls]Sheet1'!A51)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C56[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A52="",'[Promotion Detail_twb.xls]Sheet1'!B52,'[Promotion Detail_twb.xls]Sheet1'!A52)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C57[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A53="",'[Promotion Detail_twb.xls]Sheet1'!B53,'[Promotion Detail_twb.xls]Sheet1'!A53)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C58[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A54="",'[Promotion Detail_twb.xls]Sheet1'!B54,'[Promotion Detail_twb.xls]Sheet1'!A54)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C59[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A55="",'[Promotion Detail_twb.xls]Sheet1'!B55,'[Promotion Detail_twb.xls]Sheet1'!A55)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C60[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A56="",'[Promotion Detail_twb.xls]Sheet1'!B56,'[Promotion Detail_twb.xls]Sheet1'!A56)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C61[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A57="",'[Promotion Detail_twb.xls]Sheet1'!B57,'[Promotion Detail_twb.xls]Sheet1'!A57)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C62[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A58="",'[Promotion Detail_twb.xls]Sheet1'!B58,'[Promotion Detail_twb.xls]Sheet1'!A58)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C63[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A59="",'[Promotion Detail_twb.xls]Sheet1'!B59,'[Promotion Detail_twb.xls]Sheet1'!A59)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C64[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A60="",'[Promotion Detail_twb.xls]Sheet1'!B60,'[Promotion Detail_twb.xls]Sheet1'!A60)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C65[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A61="",'[Promotion Detail_twb.xls]Sheet1'!B61,'[Promotion Detail_twb.xls]Sheet1'!A61)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C66[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A62="",'[Promotion Detail_twb.xls]Sheet1'!B62,'[Promotion Detail_twb.xls]Sheet1'!A62)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C67[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A63="",'[Promotion Detail_twb.xls]Sheet1'!B63,'[Promotion Detail_twb.xls]Sheet1'!A63)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C68[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A64="",'[Promotion Detail_twb.xls]Sheet1'!B64,'[Promotion Detail_twb.xls]Sheet1'!A64)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C69[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A65="",'[Promotion Detail_twb.xls]Sheet1'!B65,'[Promotion Detail_twb.xls]Sheet1'!A65)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C70[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A66="",'[Promotion Detail_twb.xls]Sheet1'!B66,'[Promotion Detail_twb.xls]Sheet1'!A66)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S14[/TH]
[TD="align: left"]=IF(LEFT(C14,1)="6",LEFT(C14,4),C13)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S15[/TH]
[TD="align: left"]=IF(LEFT(C15,1)="6",LEFT(C15,4),C14)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S16[/TH]
[TD="align: left"]=IF(LEFT(C16,1)="6",LEFT(C16,4),C15)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S17[/TH]
[TD="align: left"]=IF(LEFT(C17,1)="6",LEFT(C17,4),C16)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S18[/TH]
[TD="align: left"]=IF(LEFT(C18,1)="6",LEFT(C18,4),C17)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S19[/TH]
[TD="align: left"]=IF(LEFT(C19,1)="6",LEFT(C19,4),C18)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S20[/TH]
[TD="align: left"]=IF(LEFT(C20,1)="6",LEFT(C20,4),C19)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S21[/TH]
[TD="align: left"]=IF(LEFT(C21,1)="6",LEFT(C21,4),C20)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S22[/TH]
[TD="align: left"]=IF(LEFT(C22,1)="6",LEFT(C22,4),C21)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S23[/TH]
[TD="align: left"]=IF(LEFT(C23,1)="6",LEFT(C23,4),C22)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S24[/TH]
[TD="align: left"]=IF(LEFT(C24,1)="6",LEFT(C24,4),C23)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S25[/TH]
[TD="align: left"]=IF(LEFT(C25,1)="6",LEFT(C25,4),C24)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S26[/TH]
[TD="align: left"]=IF(LEFT(C26,1)="6",LEFT(C26,4),C25)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S27[/TH]
[TD="align: left"]=IF(LEFT(C27,1)="6",LEFT(C27,4),C26)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S28[/TH]
[TD="align: left"]=IF(LEFT(C28,1)="6",LEFT(C28,4),C27)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S29[/TH]
[TD="align: left"]=IF(LEFT(C29,1)="6",LEFT(C29,4),C28)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S30[/TH]
[TD="align: left"]=IF(LEFT(C30,1)="6",LEFT(C30,4),C29)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S31[/TH]
[TD="align: left"]=IF(LEFT(C31,1)="6",LEFT(C31,4),C30)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S32[/TH]
[TD="align: left"]=IF(LEFT(C32,1)="6",LEFT(C32,4),C31)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S33[/TH]
[TD="align: left"]=IF(LEFT(C33,1)="6",LEFT(C33,4),C32)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S34[/TH]
[TD="align: left"]=IF(LEFT(C34,1)="6",LEFT(C34,4),C33)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S35[/TH]
[TD="align: left"]=IF(LEFT(C35,1)="6",LEFT(C35,4),C34)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S36[/TH]
[TD="align: left"]=IF(LEFT(C36,1)="6",LEFT(C36,4),C35)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S37[/TH]
[TD="align: left"]=IF(LEFT(C37,1)="6",LEFT(C37,4),C36)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S38[/TH]
[TD="align: left"]=IF(LEFT(C38,1)="6",LEFT(C38,4),C37)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S39[/TH]
[TD="align: left"]=IF(LEFT(C39,1)="6",LEFT(C39,4),C38)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S40[/TH]
[TD="align: left"]=IF(LEFT(C40,1)="6",LEFT(C40,4),C39)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S41[/TH]
[TD="align: left"]=IF(LEFT(C41,1)="6",LEFT(C41,4),C40)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S42[/TH]
[TD="align: left"]=IF(LEFT(C42,1)="6",LEFT(C42,4),C41)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S43[/TH]
[TD="align: left"]=IF(LEFT(C43,1)="6",LEFT(C43,4),C42)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S44[/TH]
[TD="align: left"]=IF(LEFT(C44,1)="6",LEFT(C44,4),C43)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S45[/TH]
[TD="align: left"]=IF(LEFT(C45,1)="6",LEFT(C45,4),C44)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S46[/TH]
[TD="align: left"]=IF(LEFT(C46,1)="6",LEFT(C46,4),C45)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S47[/TH]
[TD="align: left"]=IF(LEFT(C47,1)="6",LEFT(C47,4),C46)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S48[/TH]
[TD="align: left"]=IF(LEFT(C48,1)="6",LEFT(C48,4),C47)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S49[/TH]
[TD="align: left"]=IF(LEFT(C49,1)="6",LEFT(C49,4),C48)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S50[/TH]
[TD="align: left"]=IF(LEFT(C50,1)="6",LEFT(C50,4),C49)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S51[/TH]
[TD="align: left"]=IF(LEFT(C51,1)="6",LEFT(C51,4),C50)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S52[/TH]
[TD="align: left"]=IF(LEFT(C52,1)="6",LEFT(C52,4),C51)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S53[/TH]
[TD="align: left"]=IF(LEFT(C53,1)="6",LEFT(C53,4),C52)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S54[/TH]
[TD="align: left"]=IF(LEFT(C54,1)="6",LEFT(C54,4),C53)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S55[/TH]
[TD="align: left"]=IF(LEFT(C55,1)="6",LEFT(C55,4),C54)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S56[/TH]
[TD="align: left"]=IF(LEFT(C56,1)="6",LEFT(C56,4),C55)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S57[/TH]
[TD="align: left"]=IF(LEFT(C57,1)="6",LEFT(C57,4),C56)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S58[/TH]
[TD="align: left"]=IF(LEFT(C58,1)="6",LEFT(C58,4),C57)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
Re: If cell's contains this, do this until...

Formula in S14:
=IF(ISNUMBER(LEFT(C14,4)+0),LEFT(C14,4),S13)

Copy down.

Excel 2010
CDEFGHIJKLMNOPQRS
13Reference CellsWhat I Want
146001 24 Highway - 21926001
15L-FREE-CHIKNWFRYDRNK6001
16L-FREE-SINGLE FRYDRK6001
17N-0200-OFF FULLSALAD6001
18N-0200-OFFCOMBO6001
19N-BOGO-3PC TENDERS6001
20N-BOGO-CHICKEN6001
21N-BOGO-SINGLECHEESE6001
22N-DISC-2SGLCHZ CMB6001
23N-DISC-2SPC CHK CMB6001
24N-DISC-DBL CHZ CMB6001
25N-DISC-KM CHICKEN6001
26N-DISC-KM CHK TENDER6001
27N-DISC-KM CHZBURGER6001
28N-DISC-KM HAMBURGER6001
29N-DISC-KM NUGGET6001
30N-DISC-KM WRAPS6001
31N-FREE-COOKIE6001
32N-FREE-JRFRSTYKEYTAG6001
33N-FREE-TNDRSW/FRYDRK6001
346001 24 Highway - 2192 Quantity:6001
356002 40 Highway - 82466002
36L-FREE-CHIKNWFRYDRNK6002
37L-FREE-SINGLE FRYDRK6002
38N-0200-OFF FULLSALAD6002
39N-0200-OFFCOMBO6002
40N-BOGO-3PC TENDERS6002
41N-BOGO-CHICKEN6002
42N-BOGO-SINGLECHEESE6002
43N-DISC-2SGLCHZ CMB6002
44N-DISC-2SPC CHK CMB6002
45N-DISC-DBL CHZ CMB6002
46N-DISC-KM CHICKEN6002
47N-DISC-KM CHK TENDER6002
48N-DISC-KM CHZBURGER6002
49N-DISC-KM HAMBURGER6002
50N-DISC-KM NUGGET6002
51N-DISC-KM WRAPS6002
52N-FREE-COOKIE6002
53N-FREE-JRFRSTYKEYTAG6002
54N-FREE-TNDRSW/FRYDRK6002
556002 40 Highway - 8246 Quantity:6002
566003 State Ave - 21836003
57L-FREE-CHIKNWFRYDRNK6003
58L-FREE-SINGLE FRYDRK6003
Sheet1
Cell Formulas
RangeFormula
S14=IF(ISNUMBER(LEFT(C14,4)+0),LEFT(C14,4),S13)
S15=IF(ISNUMBER(LEFT(C15,4)+0),LEFT(C15,4),S14)
S16=IF(ISNUMBER(LEFT(C16,4)+0),LEFT(C16,4),S15)
S17=IF(ISNUMBER(LEFT(C17,4)+0),LEFT(C17,4),S16)
S18=IF(ISNUMBER(LEFT(C18,4)+0),LEFT(C18,4),S17)
S19=IF(ISNUMBER(LEFT(C19,4)+0),LEFT(C19,4),S18)
S20=IF(ISNUMBER(LEFT(C20,4)+0),LEFT(C20,4),S19)
S21=IF(ISNUMBER(LEFT(C21,4)+0),LEFT(C21,4),S20)
S22=IF(ISNUMBER(LEFT(C22,4)+0),LEFT(C22,4),S21)
S23=IF(ISNUMBER(LEFT(C23,4)+0),LEFT(C23,4),S22)
S24=IF(ISNUMBER(LEFT(C24,4)+0),LEFT(C24,4),S23)
S25=IF(ISNUMBER(LEFT(C25,4)+0),LEFT(C25,4),S24)
S26=IF(ISNUMBER(LEFT(C26,4)+0),LEFT(C26,4),S25)
S27=IF(ISNUMBER(LEFT(C27,4)+0),LEFT(C27,4),S26)
S28=IF(ISNUMBER(LEFT(C28,4)+0),LEFT(C28,4),S27)
S29=IF(ISNUMBER(LEFT(C29,4)+0),LEFT(C29,4),S28)
S30=IF(ISNUMBER(LEFT(C30,4)+0),LEFT(C30,4),S29)
S31=IF(ISNUMBER(LEFT(C31,4)+0),LEFT(C31,4),S30)
S32=IF(ISNUMBER(LEFT(C32,4)+0),LEFT(C32,4),S31)
S33=IF(ISNUMBER(LEFT(C33,4)+0),LEFT(C33,4),S32)
S34=IF(ISNUMBER(LEFT(C34,4)+0),LEFT(C34,4),S33)
S35=IF(ISNUMBER(LEFT(C35,4)+0),LEFT(C35,4),S34)
S36=IF(ISNUMBER(LEFT(C36,4)+0),LEFT(C36,4),S35)
S37=IF(ISNUMBER(LEFT(C37,4)+0),LEFT(C37,4),S36)
S38=IF(ISNUMBER(LEFT(C38,4)+0),LEFT(C38,4),S37)
S39=IF(ISNUMBER(LEFT(C39,4)+0),LEFT(C39,4),S38)
S40=IF(ISNUMBER(LEFT(C40,4)+0),LEFT(C40,4),S39)
S41=IF(ISNUMBER(LEFT(C41,4)+0),LEFT(C41,4),S40)
S42=IF(ISNUMBER(LEFT(C42,4)+0),LEFT(C42,4),S41)
S43=IF(ISNUMBER(LEFT(C43,4)+0),LEFT(C43,4),S42)
S44=IF(ISNUMBER(LEFT(C44,4)+0),LEFT(C44,4),S43)
S45=IF(ISNUMBER(LEFT(C45,4)+0),LEFT(C45,4),S44)
S46=IF(ISNUMBER(LEFT(C46,4)+0),LEFT(C46,4),S45)
S47=IF(ISNUMBER(LEFT(C47,4)+0),LEFT(C47,4),S46)
S48=IF(ISNUMBER(LEFT(C48,4)+0),LEFT(C48,4),S47)
S49=IF(ISNUMBER(LEFT(C49,4)+0),LEFT(C49,4),S48)
S50=IF(ISNUMBER(LEFT(C50,4)+0),LEFT(C50,4),S49)
S51=IF(ISNUMBER(LEFT(C51,4)+0),LEFT(C51,4),S50)
S52=IF(ISNUMBER(LEFT(C52,4)+0),LEFT(C52,4),S51)
S53=IF(ISNUMBER(LEFT(C53,4)+0),LEFT(C53,4),S52)
S54=IF(ISNUMBER(LEFT(C54,4)+0),LEFT(C54,4),S53)
S55=IF(ISNUMBER(LEFT(C55,4)+0),LEFT(C55,4),S54)
S56=IF(ISNUMBER(LEFT(C56,4)+0),LEFT(C56,4),S55)
S57=IF(ISNUMBER(LEFT(C57,4)+0),LEFT(C57,4),S56)
S58=IF(ISNUMBER(LEFT(C58,4)+0),LEFT(C58,4),S57)
 
Upvote 0
Re: If cell's contains this, do this until...

Can't you just do.....

Excel Workbook
CDES
13Reference CellsMy Formula
146001 24 Highway - 21926001
15L-FREE-CHIKNWFRYDRNK6001
16L-FREE-SINGLE FRYDRK6001
17N-0200-OFF FULLSALAD6001
18N-0200-OFFCOMBO6001
19N-BOGO-3PC TENDERS6001
20N-BOGO-CHICKEN6001
21N-BOGO-SINGLECHEESE6001
22N-DISC-2SGLCHZ CMB6001
23N-DISC-2SPC CHK CMB6001
24N-DISC-DBL CHZ CMB6001
25N-DISC-KM CHICKEN6001
26N-DISC-KM CHK TENDER6001
27N-DISC-KM CHZBURGER6001
28N-DISC-KM HAMBURGER6001
29N-DISC-KM NUGGET6001
30N-DISC-KM WRAPS6001
31N-FREE-COOKIE6001
32N-FREE-JRFRSTYKEYTAG6001
33N-FREE-TNDRSW/FRYDRK6001
346001 24 Highway - 2192 Quantity:6001
356002 40 Highway - 82466002
36L-FREE-CHIKNWFRYDRNK6002
37L-FREE-SINGLE FRYDRK6002
38N-0200-OFF FULLSALAD6002
39N-0200-OFFCOMBO6002
40N-BOGO-3PC TENDERS6002
41N-BOGO-CHICKEN6002
42N-BOGO-SINGLECHEESE6002
43N-DISC-2SGLCHZ CMB6002
44N-DISC-2SPC CHK CMB6002
45N-DISC-DBL CHZ CMB6002
46N-DISC-KM CHICKEN6002
47N-DISC-KM CHK TENDER6002
48N-DISC-KM CHZBURGER6002
49N-DISC-KM HAMBURGER6002
50N-DISC-KM NUGGET6002
51N-DISC-KM WRAPS6002
52N-FREE-COOKIE6002
53N-FREE-JRFRSTYKEYTAG6002
54N-FREE-TNDRSW/FRYDRK6002
556002 40 Highway - 8246 Quantity:6002
566003 State Ave - 21836003
57L-FREE-CHIKNWFRYDRNK6003
58L-FREE-SINGLE FRYDRK6003
Sheet2
 
Upvote 0
Re: If cell's contains this, do this until...

Hi,


Book1
CDW
13Reference CellsWhat I Want
146001 24 Highway - 21926001
15L-FREE-CHIKNWFRYDRNK6001
16L-FREE-SINGLE FRYDRK6001
17N-0200-OFF FULLSALAD6001
18N-0200-OFFCOMBO6001
19N-BOGO-3PC TENDERS6001
20N-BOGO-CHICKEN6001
21N-BOGO-SINGLECHEESE6001
22N-DISC-2SGLCHZ CMB6001
23N-DISC-2SPC CHK CMB6001
24N-DISC-DBL CHZ CMB6001
25N-DISC-KM CHICKEN6001
26N-DISC-KM CHK TENDER6001
27N-DISC-KM CHZBURGER6001
28N-DISC-KM HAMBURGER6001
29N-DISC-KM NUGGET6001
30N-DISC-KM WRAPS6001
31N-FREE-COOKIE6001
32N-FREE-JRFRSTYKEYTAG6001
33N-FREE-TNDRSW/FRYDRK6001
346001 24 Highway - 2192 Quantity:6001
356002 40 Highway - 82466002
36L-FREE-CHIKNWFRYDRNK6002
37L-FREE-SINGLE FRYDRK6002
38N-0200-OFF FULLSALAD6002
39N-0200-OFFCOMBO6002
40N-BOGO-3PC TENDERS6002
41N-BOGO-CHICKEN6002
42N-BOGO-SINGLECHEESE6002
43N-DISC-2SGLCHZ CMB6002
44N-DISC-2SPC CHK CMB6002
45N-DISC-DBL CHZ CMB6002
46N-DISC-KM CHICKEN6002
47N-DISC-KM CHK TENDER6002
48N-DISC-KM CHZBURGER6002
49N-DISC-KM HAMBURGER6002
50N-DISC-KM NUGGET6002
51N-DISC-KM WRAPS6002
52N-FREE-COOKIE6002
53N-FREE-JRFRSTYKEYTAG6002
54N-FREE-TNDRSW/FRYDRK6002
556002 40 Highway - 8246 Quantity:6002
566003 State Ave - 21836003
57L-FREE-CHIKNWFRYDRNK6003
58L-FREE-SINGLE FRYDRK6003
Sheet345
Cell Formulas
RangeFormula
W14=IF(LEFT(C14)="6",LEFT(C14,4)+0,W13)


Formula copied down.
 
Upvote 0
Re: If cell's contains this, do this until...

You can put this is S14 and dragg it down
Code: 
=IF(ISNUMBER(VALUE(LEFT(C14,4))),VALUE(LEFT(C14,4)),S13)
 
Upvote 0
Re: If cell's contains this, do this until...

Trying to write a formula to look for characters that begin with 6
Click to expand...
Maybe I am reading it wrong but a couple of posts are seeming to ignore that the question specifically states characters that begin with a 6 :confused:
 
Upvote 0
Re: If cell's contains this, do this until...

Code: 
=if(and(isnumber(value(left(c14,4))),left(c14,1)="6"),value(left(c15,4)),s13)
 
Upvote 0
Re: If cell's contains this, do this until...

Thanks everyone! Who knew there could be so many different answers for the same problem? Looks like everyone's solution worked and I would like to give a special shout out to Scott Huish and Kamolga who went one step further and made this formula useful beyond the original request of using the number 6. Thanks again and one last thing - if there was any way I can make my future posts better, be sure to let me know!

CQRSTUVWX
Reference CellsScott HMARK858jtakwKamolgaWhat I Want
6001 24 Highway - 2192
L-FREE-CHIKNWFRYDRNK
L-FREE-SINGLE FRYDRK
N-0200-OFF FULLSALAD
N-0200-OFFCOMBO
N-BOGO-3PC TENDERS
N-BOGO-CHICKEN
N-BOGO-SINGLECHEESE
N-DISC-2SGLCHZ CMB
N-DISC-2SPC CHK CMB
N-DISC-DBL CHZ CMB
N-DISC-KM CHICKEN
N-DISC-KM CHK TENDER
N-DISC-KM CHZBURGER
N-DISC-KM HAMBURGER
N-DISC-KM NUGGET
N-DISC-KM WRAPS
N-FREE-COOKIE
N-FREE-JRFRSTYKEYTAG
N-FREE-TNDRSW/FRYDRK
6001 24 Highway - 2192 Quantity:
6002 40 Highway - 8246
L-FREE-CHIKNWFRYDRNK
L-FREE-SINGLE FRYDRK
N-0200-OFF FULLSALAD
N-0200-OFFCOMBO
N-BOGO-3PC TENDERS
N-BOGO-CHICKEN
N-BOGO-SINGLECHEESE
N-DISC-2SGLCHZ CMB
N-DISC-2SPC CHK CMB
N-DISC-DBL CHZ CMB
N-DISC-KM CHICKEN
N-DISC-KM CHK TENDER
N-DISC-KM CHZBURGER
N-DISC-KM HAMBURGER
N-DISC-KM NUGGET
N-DISC-KM WRAPS
N-FREE-COOKIE
N-FREE-JRFRSTYKEYTAG
N-FREE-TNDRSW/FRYDRK
6002 40 Highway - 8246 Quantity:
6003 State Ave - 2183
L-FREE-CHIKNWFRYDRNK
L-FREE-SINGLE FRYDRK
N-0200-OFF FULLSALAD
N-0200-OFFCOMBO
N-BOGO-3PC TENDERS
N-BOGO-CHICKEN

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]13[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]16[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]17[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]18[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]19[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]20[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]21[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]22[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]23[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]24[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]25[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]26[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]27[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]28[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]29[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]30[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]31[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]32[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]33[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]34[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]35[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]36[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]37[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]38[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]39[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]40[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]41[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]42[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]43[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]44[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]45[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]46[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]47[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]48[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]49[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]50[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]51[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]52[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]53[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]54[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]55[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]

[TD="align: center"]56[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]

[TD="align: center"]57[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]

[TD="align: center"]58[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]

[TD="align: center"]59[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]

[TD="align: center"]60[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]

[TD="align: center"]61[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]

[TD="align: center"]62[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]

</tbody>
ToFormat​
 
Upvote 0
Re: If cell's contains this, do this until...

Hi Everyone - Me again! This formula served me well for months until I ran into the following problem:

Formula: The formula in column S was created to return store numbers. All my store numbers begin with 6. Example: Cell A194 is store number 6001.
What you should know: Dates are also in column A
Which Means: The formula works great until you get to the month of June, which also begins with a 6.
Actually: The formula still works with a June date until 6/10/2018???
Desired Result: Formula in column S that will continue to deliver store numbers instead of the date from column A

Can you help?

ABCDEFGHIJKLMNOPQRS
6001 Highway - 2192
5/24/2018
5/24/2018 Total:
5/25/2018
Coupon 1
5/25/2018 Total:
5/26/2018
Coupon 1
5/26/2018 Total:
5/27/2018
Coupon 1
5/27/2018 Total:
5/28/2018
Coupon 1
5/28/2018 Total:
5/29/2018
Coupon 1
5/29/2018 Total:
5/30/2018
5/30/2018 Total:
5/31/2018
Coupon 1
5/31/2018 Total:
6/1/2018
Coupon 1
6/1/2018 Total:
6/2/2018
6/2/2018 Total:
6/3/2018
Coupon 1
6/3/2018 Total:
6/4/2018
Coupon 1
6/4/2018 Total:
6/5/2018
Coupon 1
6/5/2018 Total:
6/6/2018
Coupon 1
6/6/2018 Total:
6/7/2018
6/7/2018 Total:
6/8/2018
6/8/2018 Total:
6/9/2018
6/9/2018 Total:
6/10/2018
6/10/2018 Total:
6/11/2018
Coupon 1
6/11/2018 Total:
6/12/2018
Coupon 1
6/12/2018 Total:
6/13/2018
Coupon 1
Coupon 1
6/13/2018 Total:
6/14/2018
Coupon 1
6/14/2018 Total:
6/15/2018
6/15/2018 Total:
6/16/2018
6/16/2018 Total:
6/17/2018
Coupon 1
Coupon 1
6/17/2018 Total:
6/18/2018
6/18/2018 Total:
6/19/2018
6/19/2018 Total:
6/20/2018
6/20/2018 Total:
6/21/2018

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]194[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]195[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,516.49[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]196[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]197[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]198[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4,137.76[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]199[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$6.38[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$6.40[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.15%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]200[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$6.38[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$6.40[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.15%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]201[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,612.60[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]202[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2.59[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]203[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2.59[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]204[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,121.88[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]205[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.20[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.10%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]206[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.10%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]207[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2,656.33[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]208[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2.59[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]209[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2.59[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]210[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,624.37[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]211[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2.59[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]212[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2.59[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]213[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,640.76[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]214[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]215[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]216[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,743.24[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]217[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$7.77[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]218[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$7.77[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]219[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4,338.43[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]220[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.20[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.07%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]221[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.19[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.20[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.07%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]222[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,762.59[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]223[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]224[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]225[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,519.21[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]226[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.09[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]227[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.09[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]228[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,593.66[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]229[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.69[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]230[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.69[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]231[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,320.13[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]232[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.49[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]233[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.49[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]234[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,787.81[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]235[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.79[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.79[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.13%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]236[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.79[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.13%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]237[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,426.56[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]238[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]239[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]240[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]241[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]242[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]243[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4,121.41[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]244[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]245[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]246[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4,075.87[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]247[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]248[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]249[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,145.40[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]250[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]251[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]6001[/TD]

[TD="align: center"]252[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,370.53[/TD]
[TD="align: right"]43626[/TD]

[TD="align: center"]253[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.49[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43626[/TD]

[TD="align: center"]254[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.49[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43626[/TD]

[TD="align: center"]255[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,212.89[/TD]
[TD="align: right"]43627[/TD]

[TD="align: center"]256[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.99[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43627[/TD]

[TD="align: center"]257[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.99[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43627[/TD]

[TD="align: center"]258[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,328.96[/TD]
[TD="align: right"]43628[/TD]

[TD="align: center"]259[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]($0.34)[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]($0.34)[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2.19[/TD]
[TD="align: right"]68.87%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]-0.01%[/TD]
[TD="align: right"]43628[/TD]

[TD="align: center"]260[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.99[/TD]
[TD="align: right"]31.13%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43628[/TD]

[TD="align: center"]261[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]($0.34)[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3.18[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]-0.01%[/TD]
[TD="align: right"]43628[/TD]

[TD="align: center"]262[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,928.13[/TD]
[TD="align: right"]43629[/TD]

[TD="align: center"]263[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.69[/TD]
[TD="align: right"]100.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43629[/TD]

[TD="align: center"]264[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.69[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43629[/TD]

[TD="align: center"]265[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4,605.78[/TD]
[TD="align: right"]43630[/TD]

[TD="align: center"]266[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43630[/TD]

[TD="align: center"]267[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43630[/TD]

[TD="align: center"]268[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,306.14[/TD]
[TD="align: right"]43631[/TD]

[TD="align: center"]269[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43631[/TD]

[TD="align: center"]270[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43631[/TD]

[TD="align: center"]271[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$2,586.95[/TD]
[TD="align: right"]43632[/TD]

[TD="align: center"]272[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]($0.05)[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]($0.10)[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.38[/TD]
[TD="align: right"]47.25%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43632[/TD]

[TD="align: center"]273[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$4.89[/TD]
[TD="align: right"]52.75%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43632[/TD]

[TD="align: center"]274[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]($0.10)[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$9.27[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43632[/TD]

[TD="align: center"]275[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,709.32[/TD]
[TD="align: right"]43633[/TD]

[TD="align: center"]276[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43633[/TD]

[TD="align: center"]277[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43633[/TD]

[TD="align: center"]278[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,197.75[/TD]
[TD="align: right"]43634[/TD]

[TD="align: center"]279[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43634[/TD]

[TD="align: center"]280[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43634[/TD]

[TD="align: center"]281[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,416.92[/TD]
[TD="align: right"]43635[/TD]

[TD="align: center"]282[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43635[/TD]

[TD="align: center"]283[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$0.00[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]0.00%[/TD]
[TD="align: right"]43635[/TD]

[TD="align: center"]284[/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]$3,843.91[/TD]
[TD="align: right"]43636[/TD]

</tbody>
Sheet1 (2)​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S194[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A193,4))),LEFT(A193,1)="6"),VALUE(LEFT(A193,4)),S193)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S195[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A194,4))),LEFT(A194,1)="6"),VALUE(LEFT(A194,4)),S194)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S196[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A195,4))),LEFT(A195,1)="6"),VALUE(LEFT(A195,4)),S195)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S197[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A196,4))),LEFT(A196,1)="6"),VALUE(LEFT(A196,4)),S196)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S198[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A197,4))),LEFT(A197,1)="6"),VALUE(LEFT(A197,4)),S197)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S199[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A198,4))),LEFT(A198,1)="6"),VALUE(LEFT(A198,4)),S198)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S200[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A199,4))),LEFT(A199,1)="6"),VALUE(LEFT(A199,4)),S199)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S201[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A200,4))),LEFT(A200,1)="6"),VALUE(LEFT(A200,4)),S200)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S202[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A201,4))),LEFT(A201,1)="6"),VALUE(LEFT(A201,4)),S201)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S203[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A202,4))),LEFT(A202,1)="6"),VALUE(LEFT(A202,4)),S202)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S204[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A203,4))),LEFT(A203,1)="6"),VALUE(LEFT(A203,4)),S203)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S205[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A204,4))),LEFT(A204,1)="6"),VALUE(LEFT(A204,4)),S204)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S206[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A205,4))),LEFT(A205,1)="6"),VALUE(LEFT(A205,4)),S205)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S207[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A206,4))),LEFT(A206,1)="6"),VALUE(LEFT(A206,4)),S206)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S208[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A207,4))),LEFT(A207,1)="6"),VALUE(LEFT(A207,4)),S207)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S209[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A208,4))),LEFT(A208,1)="6"),VALUE(LEFT(A208,4)),S208)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S210[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A209,4))),LEFT(A209,1)="6"),VALUE(LEFT(A209,4)),S209)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S211[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A210,4))),LEFT(A210,1)="6"),VALUE(LEFT(A210,4)),S210)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S212[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A211,4))),LEFT(A211,1)="6"),VALUE(LEFT(A211,4)),S211)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S213[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A212,4))),LEFT(A212,1)="6"),VALUE(LEFT(A212,4)),S212)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S214[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A213,4))),LEFT(A213,1)="6"),VALUE(LEFT(A213,4)),S213)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S215[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A214,4))),LEFT(A214,1)="6"),VALUE(LEFT(A214,4)),S214)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S216[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A215,4))),LEFT(A215,1)="6"),VALUE(LEFT(A215,4)),S215)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S217[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A216,4))),LEFT(A216,1)="6"),VALUE(LEFT(A216,4)),S216)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S218[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A217,4))),LEFT(A217,1)="6"),VALUE(LEFT(A217,4)),S217)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S219[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A218,4))),LEFT(A218,1)="6"),VALUE(LEFT(A218,4)),S218)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S220[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A219,4))),LEFT(A219,1)="6"),VALUE(LEFT(A219,4)),S219)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S221[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A220,4))),LEFT(A220,1)="6"),VALUE(LEFT(A220,4)),S220)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S222[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A221,4))),LEFT(A221,1)="6"),VALUE(LEFT(A221,4)),S221)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S223[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A222,4))),LEFT(A222,1)="6"),VALUE(LEFT(A222,4)),S222)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S224[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A223,4))),LEFT(A223,1)="6"),VALUE(LEFT(A223,4)),S223)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S225[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A224,4))),LEFT(A224,1)="6"),VALUE(LEFT(A224,4)),S224)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S226[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A225,4))),LEFT(A225,1)="6"),VALUE(LEFT(A225,4)),S225)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S227[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A226,4))),LEFT(A226,1)="6"),VALUE(LEFT(A226,4)),S226)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S228[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A227,4))),LEFT(A227,1)="6"),VALUE(LEFT(A227,4)),S227)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S229[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A228,4))),LEFT(A228,1)="6"),VALUE(LEFT(A228,4)),S228)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S230[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A229,4))),LEFT(A229,1)="6"),VALUE(LEFT(A229,4)),S229)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S231[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A230,4))),LEFT(A230,1)="6"),VALUE(LEFT(A230,4)),S230)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S232[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A231,4))),LEFT(A231,1)="6"),VALUE(LEFT(A231,4)),S231)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S233[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A232,4))),LEFT(A232,1)="6"),VALUE(LEFT(A232,4)),S232)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S234[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A233,4))),LEFT(A233,1)="6"),VALUE(LEFT(A233,4)),S233)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S235[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A234,4))),LEFT(A234,1)="6"),VALUE(LEFT(A234,4)),S234)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S236[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A235,4))),LEFT(A235,1)="6"),VALUE(LEFT(A235,4)),S235)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S237[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A236,4))),LEFT(A236,1)="6"),VALUE(LEFT(A236,4)),S236)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S238[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A237,4))),LEFT(A237,1)="6"),VALUE(LEFT(A237,4)),S237)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S239[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A238,4))),LEFT(A238,1)="6"),VALUE(LEFT(A238,4)),S238)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S240[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A239,4))),LEFT(A239,1)="6"),VALUE(LEFT(A239,4)),S239)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S241[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A240,4))),LEFT(A240,1)="6"),VALUE(LEFT(A240,4)),S240)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S242[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A241,4))),LEFT(A241,1)="6"),VALUE(LEFT(A241,4)),S241)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S243[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A242,4))),LEFT(A242,1)="6"),VALUE(LEFT(A242,4)),S242)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S244[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A243,4))),LEFT(A243,1)="6"),VALUE(LEFT(A243,4)),S243)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S245[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A244,4))),LEFT(A244,1)="6"),VALUE(LEFT(A244,4)),S244)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S246[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A245,4))),LEFT(A245,1)="6"),VALUE(LEFT(A245,4)),S245)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S247[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A246,4))),LEFT(A246,1)="6"),VALUE(LEFT(A246,4)),S246)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S248[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A247,4))),LEFT(A247,1)="6"),VALUE(LEFT(A247,4)),S247)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S249[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A248,4))),LEFT(A248,1)="6"),VALUE(LEFT(A248,4)),S248)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S250[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A249,4))),LEFT(A249,1)="6"),VALUE(LEFT(A249,4)),S249)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S251[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A250,4))),LEFT(A250,1)="6"),VALUE(LEFT(A250,4)),S250)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S252[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A251,4))),LEFT(A251,1)="6"),VALUE(LEFT(A251,4)),S251)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S253[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A252,4))),LEFT(A252,1)="6"),VALUE(LEFT(A252,4)),S252)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S254[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A253,4))),LEFT(A253,1)="6"),VALUE(LEFT(A253,4)),S253)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S255[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A254,4))),LEFT(A254,1)="6"),VALUE(LEFT(A254,4)),S254)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S256[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A255,4))),LEFT(A255,1)="6"),VALUE(LEFT(A255,4)),S255)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S257[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A256,4))),LEFT(A256,1)="6"),VALUE(LEFT(A256,4)),S256)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S258[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A257,4))),LEFT(A257,1)="6"),VALUE(LEFT(A257,4)),S257)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S259[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A258,4))),LEFT(A258,1)="6"),VALUE(LEFT(A258,4)),S258)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S260[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A259,4))),LEFT(A259,1)="6"),VALUE(LEFT(A259,4)),S259)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S261[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A260,4))),LEFT(A260,1)="6"),VALUE(LEFT(A260,4)),S260)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S262[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A261,4))),LEFT(A261,1)="6"),VALUE(LEFT(A261,4)),S261)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S263[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A262,4))),LEFT(A262,1)="6"),VALUE(LEFT(A262,4)),S262)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S264[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A263,4))),LEFT(A263,1)="6"),VALUE(LEFT(A263,4)),S263)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S265[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A264,4))),LEFT(A264,1)="6"),VALUE(LEFT(A264,4)),S264)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S266[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A265,4))),LEFT(A265,1)="6"),VALUE(LEFT(A265,4)),S265)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S267[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A266,4))),LEFT(A266,1)="6"),VALUE(LEFT(A266,4)),S266)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S268[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A267,4))),LEFT(A267,1)="6"),VALUE(LEFT(A267,4)),S267)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S269[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A268,4))),LEFT(A268,1)="6"),VALUE(LEFT(A268,4)),S268)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S270[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A269,4))),LEFT(A269,1)="6"),VALUE(LEFT(A269,4)),S269)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S271[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A270,4))),LEFT(A270,1)="6"),VALUE(LEFT(A270,4)),S270)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S272[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A271,4))),LEFT(A271,1)="6"),VALUE(LEFT(A271,4)),S271)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S273[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A272,4))),LEFT(A272,1)="6"),VALUE(LEFT(A272,4)),S272)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S274[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A273,4))),LEFT(A273,1)="6"),VALUE(LEFT(A273,4)),S273)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S275[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A274,4))),LEFT(A274,1)="6"),VALUE(LEFT(A274,4)),S274)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S276[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A275,4))),LEFT(A275,1)="6"),VALUE(LEFT(A275,4)),S275)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S277[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A276,4))),LEFT(A276,1)="6"),VALUE(LEFT(A276,4)),S276)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S278[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A277,4))),LEFT(A277,1)="6"),VALUE(LEFT(A277,4)),S277)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S279[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A278,4))),LEFT(A278,1)="6"),VALUE(LEFT(A278,4)),S278)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S280[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A279,4))),LEFT(A279,1)="6"),VALUE(LEFT(A279,4)),S279)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S281[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A280,4))),LEFT(A280,1)="6"),VALUE(LEFT(A280,4)),S280)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S282[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A281,4))),LEFT(A281,1)="6"),VALUE(LEFT(A281,4)),S281)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S283[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A282,4))),LEFT(A282,1)="6"),VALUE(LEFT(A282,4)),S282)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S284[/TH]
[TD="align: left"]=IF(AND(ISNUMBER(VALUE(LEFT(A283,4))),LEFT(A283,1)="6"),VALUE(LEFT(A283,4)),S283)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
Re: If cell's contains this, do this until...

Add an additional constraint that the value has to be less than 7,000? Excel sees dates as numbers so 1=1/1/1900 and june 2018 is that 43,000ish you're getting.
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question Question
How do I redistribute sales fairly if I want to increase the growth percentage?
Replies
5
Views
1K
igold
igold

Forum statistics

Threads
1,223,898
Messages
6,175,272
Members
452,628
Latest member
dd2

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