Sono contento che ci abbia aiutato. Per il numero di righe continue che impostano il flag, stavo andando alla descrizione originale "Voglio impostare il valore col (x) su 1 quando la riga corrente e le successive 5 righe per neve contengono dati neve (> 0)."
Per il rigoroso requisito n = 5 basta cambiare
style = "WORD-SPACING: 0px; FONT: 16px / 20px 'Times New Roman'; TEXT-TRANSFORM: none; COLORE: rgb (0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normale; LETTERA -SPACING: normale; BORDER-COLLAPSE: separato; TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-border-horizontal-spacing: 0px; webkit-border-vertical-spacing: 0px; webkit-text-decorations -in-effetto: none; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px ">
class = di Apple-style-arco
style = "FONT-SIZE: 13px; LINE-HEIGHT: 16px; FONT-FAMILY: arial, helvetica, sans-serif">
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
class = Mela-convertito-space>
style = "FONT-SIZE: 10pt; COLOR: rgb (0,0,221); FONT-FAMILY:" Courier New ""> Se
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> (
style = "FONT-SIZE: 10pt; COLOR: rgb (0,0,221); FONT-FAMILY: 'Courier New'">> Max
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> (
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
class = Mela-convertito-space> S
class = Mela-convertito-space> )
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'" >>
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> n
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: verde acqua; FONT-FAMILY: 'Courier New'"> 1
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'"> 0
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
class = Mela-convertito-space> )
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">;
in
style = "WORD-SPACING: 0px; FONT: 16px / 20px 'Times New Roman'; TEXT-TRANSFORM: none; COLORE: rgb (0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normale; LETTERA -SPACING: normale; BORDER-COLLAPSE: separato; TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-border-horizontal-spacing: 0px; webkit-border-vertical-spacing: 0px; webkit-text-decorations -in-effetto: none; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px ">
class = di Apple-style-arco
style = "FONT-SIZE: 13px; LINE-HEIGHT: 16px; FONT-FAMILY: arial, helvetica, sans-serif">
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">
class = di Apple-style-arco
style = "WORD-SPACING: 0px; FONT: 16px / 20px 'Times New Roman'; TEXT-TRANSFORM: none; COLORE: rgb (0,0,0); TEXT-INDENT: 0px; WHITE-SPACE: normale; LETTERA -SPACING: normale; BORDER-COLLAPSE: separato; TEXT-ALIGN: left; orphans: 2; widows: 2; webkit-border-horizontal-spacing: 0px; webkit-border-vertical-spacing: 0px; webkit-text-decorations -in-effetto: none; webkit-text-size-adjust: auto; webkit-text-stroke-width: 0px ">
class = di Apple-style-arco
style = "FONT-SIZE: 13px; LINE-HEIGHT: 16px; FONT-FAMILY: arial, helvetica, sans-serif">
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
class = Mela-convertito-space>
style = "FONT-SIZE: 10pt; COLOR: rgb (0,0,221); FONT-FAMILY:" Courier New ""> Se
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> (
style = "FONT-SIZE: 10pt; COLOR: rgb (0,0,221); FONT-FAMILY: 'Courier New'">> Max
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> (
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
class = Mela-convertito-space> S
class = Mela-convertito-space> )
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">
color = red> > =
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> n
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: verde acqua; FONT-FAMILY: 'Courier New'"> 1
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'"> 0
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
class = Mela-convertito-space> )
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">;
per mantenere il codice più leggibile.Prova a seguire la formula. "N = 5" definisce che imposterà il flag su 1 per tutti gli eventi quando> 5 righe di una riga hanno dati neve> 0. Spero che questo ti aiuti.
style = "FONT-SIZE: 10pt; COLOR: # 0000dd; FONT-FAMILY: 'Courier New'"> Local
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> (
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
{ io
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
n
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> =
style = "FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'"> 5
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> s
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> =
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLOR: # 0000dd; FONT-FAMILY: 'Courier New'"> J
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> (
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'"> 2
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> * *
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> n
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> +
style = "FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'"> 2
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: verde acqua; FONT-FAMILY: 'Courier New'"> 1
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'"> 0
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
)}
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "mso-tab-count: 1">
style = "FONT-SIZE: 10pt; COLOR: # 0000dd; FONT-FAMILY: 'Courier New'"> Per
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> (
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> i
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> =
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> -
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> n
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> i
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> <=
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
n
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
io
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> ++,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "mso-tab-count: 2">
style = "FONT-SIZE: 10pt; COLOR: # 0000dd; FONT-FAMILY: 'Courier New'">> Se
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> (
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">:
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> Neve [
style = "FONT-SIZE: 10pt; COLOR: # 0000dd; FONT-FAMILY: 'Courier New'"> Riga
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> ()
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> +
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
io
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLOR: # 0000dd; FONT-FAMILY: 'Courier New'"> Vuoto
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> ()]
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'" >>
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'"> 0
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "mso-tab-count: 3">
S [ io
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> +
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
n
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> +
style = "FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'"> 2
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: verde acqua; FONT-FAMILY: 'Courier New'"> 1
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">]
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> =
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> s [( io
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> +
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
n
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> +
style = "FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'"> 2
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">)
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> -
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: verde acqua; FONT-FAMILY: 'Courier New'"> 1
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: verde acqua; FONT-FAMILY: 'Courier New'"> 1
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">]
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'"> +
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: verde acqua; FONT-FAMILY: 'Courier New'"> 1
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "mso-tab-count: 2">
)
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "mso-tab-count: 1">
)
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">;
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "mso-tab-count: 1">
style = "FONT-SIZE: 10pt; COLOR: # 0000dd; FONT-FAMILY: 'Courier New'">> Se
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> (
style = "FONT-SIZE: 10pt; COLOR: # 0000dd; FONT-FAMILY: 'Courier New'">> Max
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> (
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> s
)
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'" >>
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'"> n
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLORE: verde acqua; FONT-FAMILY: 'Courier New'"> 1
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">,
style = "FONT-SIZE: 10pt; COLOR: teal; FONT-FAMILY: 'Courier New'"> 0
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
)
style = "FONT-SIZE: 10pt; COLORE: navy; FONT-FAMILY: 'Courier New'">;
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">
style = "FONT-SIZE: 10pt; COLORE: nero; FONT-FAMILY: 'Courier New'">)