Ordering Calendar, Arrays Excel

[rohankekatpure1987]

Hi Team,

I'm struggling in developing an ordering system in excel. Can you please help:

Below is my data :
[TABLE="width: 729"]
<tbody>[TR]
[TD="align: center"]Item[/TD]
[TD="align: center"]Order Closed [/TD]
[TD="align: center"]Sun-29[/TD]
[TD="align: center"]Mon-30[/TD]
[TD="align: center"]Tue-31[/TD]
[TD="align: center"]Wed-1[/TD]
[TD="align: center"]Thu-2[/TD]
[TD="align: center"]Fri-3[/TD]
[TD="align: center"]Sat-4[/TD]
[/TR]
[TR]
[TD="align: center"]Seafood[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]85.44[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]42.72[/TD]
[TD="align: center"]56.96[/TD]
[TD="align: center"]56.96[/TD]
[/TR]
[TR]
[TD="align: center"]Bakery[/TD]
[TD="align: center"]3,4[/TD]
[TD="align: center"]136.08[/TD]
[TD="align: center"]24.68[/TD]
[TD="align: center"]21.68[/TD]
[TD="align: center"]22.68[/TD]
[TD="align: center"]68.04[/TD]
[TD="align: center"]90.72[/TD]
[TD="align: center"]90.72[/TD]
[/TR]
[TR]
[TD="align: center"]Meat[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]123.48[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]61.74[/TD]
[TD="align: center"]82.32[/TD]
[TD="align: center"]82.32[/TD]
[/TR]
[TR]
[TD="align: center"]Produce[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]137.34[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]68.67[/TD]
[TD="align: center"]91.56[/TD]
[TD="align: center"]91.56[/TD]
[/TR]
[TR]
[TD="align: center"]Daily[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]129.78[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]64.89[/TD]
[TD="align: center"]86.52[/TD]
[TD="align: center"]86.52[/TD]
[/TR]
</tbody>[/TABLE]

Data Description:
A. Item indicates item description.
B. Order Closed : Day of the week we don't order
0: Order on all days; 1: No ordering on Sunday, 2: No ordering on Monday, 3: No ordering on Tuesday........
C. Sun-29, Mon-30, Tue 31: Quantities that needs to be ordered on a particular day.

Eg. For seafood, since order closed is zero, we need to order on all 7 days of the week. Sunday: 85.44; Tue: 14.24
For Bakery, since order closed is 3,4; We are not going to order on Tuesday and Wednesday and hence the above filled quantities 21.68, 22.68 are incorrect. The correct values will be 0 for both Tue and Wed and you will order 24.68 + 21.68 + 22.68=68.04 on Monday.

Similarly for Meat, Produce and Daily, the order quantities are incorrect as Order Closed column has values.

Can you please help me develop a formula for correcting the incorrect values for all columns From Sun to Sat for all items.

Expected Output is :

Bold quantities are added with previous day order quantities.
[TABLE="width: 729"]
<tbody>[TR]
[TD="align: center"]Description[/TD]
[TD="align: center"]Order Closed [/TD]
[TD="align: center"]Sun-29[/TD]
[TD="align: center"]Mon-30[/TD]
[TD="align: center"]Tue-31[/TD]
[TD="align: center"]Wed-1[/TD]
[TD="align: center"]Thu-2[/TD]
[TD="align: center"]Fri-3[/TD]
[TD="align: center"]Sat-4[/TD]
[/TR]
[TR]
[TD="align: center"]Seafood[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]85.44[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]42.72[/TD]
[TD="align: center"]56.96[/TD]
[TD="align: center"]56.96[/TD]
[/TR]
[TR]
[TD="align: center"]Bakery[/TD]
[TD="align: center"]3,4[/TD]
[TD="align: center"]136.08[/TD]
[TD="align: center"]69.04[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]68.04[/TD]
[TD="align: center"]90.72[/TD]
[TD="align: center"]90.72[/TD]
[/TR]
[TR]
[TD="align: center"]Meat[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]123.48[/TD]
[TD="align: center"]41.16[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]61.74[/TD]
[TD="align: center"]82.32[/TD]
[TD="align: center"]82.32[/TD]
[/TR]
[TR]
[TD="align: center"]Produce[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]137.34[/TD]
[TD="align: center"]45.78[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]68.67[/TD]
[TD="align: center"]91.56[/TD]
[TD="align: center"]91.56[/TD]
[/TR]
[TR]
[TD="align: center"]Daily[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]64.89[/TD]
[TD="align: center"]86.52[/TD]
[TD="align: center"]86.52[/TD]
[/TR]
</tbody>[/TABLE]

​

Can you help me in writing formula where based on order closed, my order quantities will automatically get added to previous day.

Thanks in advance

 

[wideboydixon]

I did take a look at this but it's quite complex to do this with formulas I think. In the end the best I could manage quickly was a two step process:

	A	B	C	D	E	F	G	H	I

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Item[/TD]
[TD="align: center"]Order Closed[/TD]
[TD="align: center"]Sun-29[/TD]
[TD="align: center"]Mon-30[/TD]
[TD="align: center"]Tue-31[/TD]
[TD="align: center"]Wed-1[/TD]
[TD="align: center"]Thu-2[/TD]
[TD="align: center"]Fri-3[/TD]
[TD="align: center"]Sat-4[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]Seafood[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]85.44[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]42.72[/TD]
[TD="align: center"]56.96[/TD]
[TD="align: center"]56.96[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]Bakery[/TD]
[TD="align: center"]3,4[/TD]
[TD="align: center"]136.08[/TD]
[TD="align: center"]24.68[/TD]
[TD="align: center"]21.68[/TD]
[TD="align: center"]22.68[/TD]
[TD="align: center"]68.04[/TD]
[TD="align: center"]90.72[/TD]
[TD="align: center"]90.72[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]Meat[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]123.48[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]61.74[/TD]
[TD="align: center"]82.32[/TD]
[TD="align: center"]82.32[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]Produce[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]137.34[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]68.67[/TD]
[TD="align: center"]91.56[/TD]
[TD="align: center"]91.56[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]Daily[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]129.78[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]64.89[/TD]
[TD="align: center"]86.52[/TD]
[TD="align: center"]86.52[/TD]

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

[TD="align: center"]8[/TD]
[TD="align: center"]Seafood[/TD]
[TD="align: center"][/TD]
[TD="align: center"]85.44[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]42.72[/TD]
[TD="align: center"]56.96[/TD]
[TD="align: center"]56.96[/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]Bakery[/TD]
[TD="align: center"][/TD]
[TD="align: center"]136.08[/TD]
[TD="align: center"]24.68[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]68.04[/TD]
[TD="align: center"]90.72[/TD]
[TD="align: center"]90.72[/TD]

[TD="align: center"]10[/TD]
[TD="align: center"]Meat[/TD]
[TD="align: center"][/TD]
[TD="align: center"]123.48[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]61.74[/TD]
[TD="align: center"]82.32[/TD]
[TD="align: center"]82.32[/TD]

[TD="align: center"]11[/TD]
[TD="align: center"]Produce[/TD]
[TD="align: center"][/TD]
[TD="align: center"]137.34[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]68.67[/TD]
[TD="align: center"]91.56[/TD]
[TD="align: center"]91.56[/TD]

[TD="align: center"]12[/TD]
[TD="align: center"]Daily[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]64.89[/TD]
[TD="align: center"]86.52[/TD]
[TD="align: center"]86.52[/TD]

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

[TD="align: center"]14[/TD]
[TD="align: center"]Seafood[/TD]
[TD="align: center"][/TD]
[TD="align: center"]85.44[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]42.72[/TD]
[TD="align: center"]56.96[/TD]
[TD="align: center"]56.96[/TD]

[TD="align: center"]15[/TD]
[TD="align: center"]Bakery[/TD]
[TD="align: center"][/TD]
[TD="align: center"]136.08[/TD]
[TD="align: center"]69.04[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]68.04[/TD]
[TD="align: center"]90.72[/TD]
[TD="align: center"]90.72[/TD]

[TD="align: center"]16[/TD]
[TD="align: center"]Meat[/TD]
[TD="align: center"][/TD]
[TD="align: center"]123.48[/TD]
[TD="align: center"]41.16[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]61.74[/TD]
[TD="align: center"]82.32[/TD]
[TD="align: center"]82.32[/TD]

[TD="align: center"]17[/TD]
[TD="align: center"]Produce[/TD]
[TD="align: center"][/TD]
[TD="align: center"]137.34[/TD]
[TD="align: center"]45.78[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]68.67[/TD]
[TD="align: center"]91.56[/TD]
[TD="align: center"]91.56[/TD]

[TD="align: center"]18[/TD]
[TD="align: center"]Daily[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]64.89[/TD]
[TD="align: center"]86.52[/TD]
[TD="align: center"]86.52[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: #DAE7F5"]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C8[/TH]
[TD="align: left"]=IF($B2 = 0, C2, IF(IFERROR(FIND(TEXT(WEEKDAY(C$1), "0"), TEXT($B2, "0")), 0) > 0, 0, C2))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A8[/TH]
[TD="align: left"]=A2[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]C14[/TH]
[TD="align: left"]=IF(C8 = 0, 0, C8 + (IF(D8 = 0, D2 + IF(E8 = 0, E2 + IF(F8 = 0, F2 + IF(G8 = 0, G2 + IF(H8 = 0, H2 + IF(I8 = 0, I2))))))))[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: #DAE7F5"]A14[/TH]
[TD="align: left"]=A8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

It would be easier with a macro where you could put the logic in a one-step process.

WBD

 

[rohankekatpure1987]

I did take a look at this but it's quite complex to do this with formulas I think. In the end the best I could manage quickly was a two step process:

	A	B	C	D	E	F	G	H	I

<tbody>
[TD="align: center"]1[/TD]
[TD="align: center"]Item[/TD]
[TD="align: center"]Order Closed[/TD]
[TD="align: center"]Sun-29[/TD]
[TD="align: center"]Mon-30[/TD]
[TD="align: center"]Tue-31[/TD]
[TD="align: center"]Wed-1[/TD]
[TD="align: center"]Thu-2[/TD]
[TD="align: center"]Fri-3[/TD]
[TD="align: center"]Sat-4[/TD]

[TD="align: center"]2[/TD]
[TD="align: center"]Seafood[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]85.44[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]42.72[/TD]
[TD="align: center"]56.96[/TD]
[TD="align: center"]56.96[/TD]

[TD="align: center"]3[/TD]
[TD="align: center"]Bakery[/TD]
[TD="align: center"]3,4[/TD]
[TD="align: center"]136.08[/TD]
[TD="align: center"]24.68[/TD]
[TD="align: center"]21.68[/TD]
[TD="align: center"]22.68[/TD]
[TD="align: center"]68.04[/TD]
[TD="align: center"]90.72[/TD]
[TD="align: center"]90.72[/TD]

[TD="align: center"]4[/TD]
[TD="align: center"]Meat[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]123.48[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]61.74[/TD]
[TD="align: center"]82.32[/TD]
[TD="align: center"]82.32[/TD]

[TD="align: center"]5[/TD]
[TD="align: center"]Produce[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"]137.34[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]68.67[/TD]
[TD="align: center"]91.56[/TD]
[TD="align: center"]91.56[/TD]

[TD="align: center"]6[/TD]
[TD="align: center"]Daily[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"]129.78[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]64.89[/TD]
[TD="align: center"]86.52[/TD]
[TD="align: center"]86.52[/TD]

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

[TD="align: center"]8[/TD]
[TD="align: center"]Seafood[/TD]
[TD="align: center"][/TD]
[TD="align: center"]85.44[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]42.72[/TD]
[TD="align: center"]56.96[/TD]
[TD="align: center"]56.96[/TD]

[TD="align: center"]9[/TD]
[TD="align: center"]Bakery[/TD]
[TD="align: center"][/TD]
[TD="align: center"]136.08[/TD]
[TD="align: center"]24.68[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]68.04[/TD]
[TD="align: center"]90.72[/TD]
[TD="align: center"]90.72[/TD]

[TD="align: center"]10[/TD]
[TD="align: center"]Meat[/TD]
[TD="align: center"][/TD]
[TD="align: center"]123.48[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]61.74[/TD]
[TD="align: center"]82.32[/TD]
[TD="align: center"]82.32[/TD]

[TD="align: center"]11[/TD]
[TD="align: center"]Produce[/TD]
[TD="align: center"][/TD]
[TD="align: center"]137.34[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]68.67[/TD]
[TD="align: center"]91.56[/TD]
[TD="align: center"]91.56[/TD]

[TD="align: center"]12[/TD]
[TD="align: center"]Daily[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]64.89[/TD]
[TD="align: center"]86.52[/TD]
[TD="align: center"]86.52[/TD]

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

[TD="align: center"]14[/TD]
[TD="align: center"]Seafood[/TD]
[TD="align: center"][/TD]
[TD="align: center"]85.44[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]14.24[/TD]
[TD="align: center"]42.72[/TD]
[TD="align: center"]56.96[/TD]
[TD="align: center"]56.96[/TD]

[TD="align: center"]15[/TD]
[TD="align: center"]Bakery[/TD]
[TD="align: center"][/TD]
[TD="align: center"]136.08[/TD]
[TD="align: center"]69.04[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]68.04[/TD]
[TD="align: center"]90.72[/TD]
[TD="align: center"]90.72[/TD]

[TD="align: center"]16[/TD]
[TD="align: center"]Meat[/TD]
[TD="align: center"][/TD]
[TD="align: center"]123.48[/TD]
[TD="align: center"]41.16[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20.58[/TD]
[TD="align: center"]61.74[/TD]
[TD="align: center"]82.32[/TD]
[TD="align: center"]82.32[/TD]

[TD="align: center"]17[/TD]
[TD="align: center"]Produce[/TD]
[TD="align: center"][/TD]
[TD="align: center"]137.34[/TD]
[TD="align: center"]45.78[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]22.89[/TD]
[TD="align: center"]68.67[/TD]
[TD="align: center"]91.56[/TD]
[TD="align: center"]91.56[/TD]

[TD="align: center"]18[/TD]
[TD="align: center"]Daily[/TD]
[TD="align: center"][/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]21.63[/TD]
[TD="align: center"]64.89[/TD]
[TD="align: center"]86.52[/TD]
[TD="align: center"]86.52[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]C8[/TH]
[TD="align: left"]=IF($B2 = 0, C2, IF(IFERROR(FIND(TEXT(WEEKDAY(C$1), "0"), TEXT($B2, "0")), 0) > 0, 0, C2))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]A8[/TH]
[TD="align: left"]=A2[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]C14[/TH]
[TD="align: left"]=IF(C8 = 0, 0, C8 + (IF(D8 = 0, D2 + IF(E8 = 0, E2 + IF(F8 = 0, F2 + IF(G8 = 0, G2 + IF(H8 = 0, H2 + IF(I8 = 0, I2))))))))[/TD]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]A14[/TH]
[TD="align: left"]=A8[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

It would be easier with a macro where you could put the logic in a one-step process.

WBD

Thanks for the quick reply wideboydixon . You are my saviour Good logic.