Formula for the last column data

[jevi]

Hi All:

I have a evaluation sheet and i have to do it on monthly basis for each branch. But if i find the formula i am looking i will have less work to do it each month. As you can see in the table below the total is equal to the last month that is fullfilled with data, that in this case is May, but when i fill wth June column with data I would like the formula of column TOTAL to be =June Column and not May. Is there any chance?

<TABLE style="WIDTH: 633pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=846 border=0><COLGROUP><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" span=3 width=79><COL style="WIDTH: 63pt; mso-width-source: userset; mso-width-alt: 3072" width=84><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 67pt; mso-width-source: userset; mso-width-alt: 3254" width=89><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><COL style="WIDTH: 74pt; mso-width-source: userset; mso-width-alt: 3620" width=99><COL style="WIDTH: 75pt; mso-width-source: userset; mso-width-alt: 3657" width=100><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><TBODY><TR style="HEIGHT: 16.9pt; mso-height-source: userset" height=22><TD class=xl77 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 59pt; BORDER-BOTTOM: #969696 0.5pt solid; HEIGHT: 33.8pt; BACKGROUND-COLOR: transparent" width=79 height=44 rowSpan=2>APRIL</TD><TD class=xl77 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 59pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" width=79 rowSpan=2>MAY</TD><TD class=xl77 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 59pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" width=79 rowSpan=2>JUNE</TD><TD class=xl77 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 63pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" width=84 rowSpan=2>JULY</TD><TD class=xl77 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 59pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" width=79 rowSpan=2>AUGUST</TD><TD class=xl77 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 67pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" width=89 rowSpan=2>SEPTEMBER</TD><TD class=xl77 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 59pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" width=79 rowSpan=2>OCTOBER</TD><TD class=xl77 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 74pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" width=99 rowSpan=2>NOVEMBER</TD><TD class=xl73 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: #969696 0.5pt solid; WIDTH: 75pt; BORDER-BOTTOM: #969696 0.5pt solid; BACKGROUND-COLOR: transparent" width=100 rowSpan=2>DECEMBER</TD><TD class=xl75 style="BORDER-RIGHT: #7f7f7f 0.5pt solid; BORDER-TOP: #969696 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; WIDTH: 59pt; BORDER-BOTTOM: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: transparent" width=79 rowSpan=2>TOTALS</TD></TR><TR style="HEIGHT: 16.9pt; mso-height-source: userset" height=22></TR><TR style="HEIGHT: 16.9pt; mso-height-source: userset" height=22><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 16.9pt; BACKGROUND-COLOR: transparent" height=22>31.6%</TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent">20.9%</TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BORDER-LEFT: gray 0.5pt solid; COLOR: white; BORDER-BOTTOM: gray 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; mso-background-source: auto; mso-pattern: auto; text-underline-style: none; text-line-through: none"> </TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: gray 0.5pt solid; COLOR: white; BORDER-BOTTOM: gray 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; mso-background-source: auto; mso-pattern: auto; text-underline-style: none; text-line-through: none"> </TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: gray 0.5pt solid; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl70 style="BORDER-RIGHT: #7f7f7f 0.5pt solid; BORDER-TOP: #7f7f7f; BORDER-LEFT: windowtext; BORDER-BOTTOM: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>20.9%</TD></TR><TR style="HEIGHT: 16.9pt; mso-height-source: userset" height=22><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 16.9pt; BACKGROUND-COLOR: transparent" height=22>37.2%</TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent">26.7%</TD><TD class=xl66 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: gray 0.5pt solid; COLOR: white; BORDER-BOTTOM: gray 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; mso-background-source: auto; mso-pattern: auto; text-underline-style: none; text-line-through: none"> </TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl65 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: gray 0.5pt solid; COLOR: white; BORDER-BOTTOM: gray 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; mso-background-source: auto; mso-pattern: auto; text-underline-style: none; text-line-through: none"> </TD><TD class=xl67 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: gray; BORDER-LEFT: gray; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl71 style="BORDER-RIGHT: #7f7f7f 0.5pt solid; BORDER-TOP: #7f7f7f; BORDER-LEFT: windowtext; BORDER-BOTTOM: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>26.7%</TD></TR><TR style="HEIGHT: 16.9pt; mso-height-source: userset" height=22><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 16.9pt; BACKGROUND-COLOR: transparent" height=22>13.6%</TD><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent">11.9%</TD><TD class=xl66 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: gray 0.5pt solid; COLOR: white; BORDER-BOTTOM: gray 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; mso-background-source: auto; mso-pattern: auto; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: gray 0.5pt solid; COLOR: white; BORDER-BOTTOM: gray 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; mso-background-source: auto; mso-pattern: auto; text-underline-style: none; text-line-through: none"> </TD><TD class=xl69 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl71 style="BORDER-RIGHT: #7f7f7f 0.5pt solid; BORDER-TOP: #7f7f7f; BORDER-LEFT: windowtext; BORDER-BOTTOM: #7f7f7f 0.5pt solid; BACKGROUND-COLOR: transparent" align=right>11.9%</TD></TR><TR style="HEIGHT: 16.9pt; mso-height-source: userset" height=22><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; HEIGHT: 16.9pt; BACKGROUND-COLOR: transparent" height=22>12.2%</TD><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent">13.4%</TD><TD class=xl66 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: gray 0.5pt solid; COLOR: white; BORDER-BOTTOM: gray 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; mso-background-source: auto; mso-pattern: auto; text-underline-style: none; text-line-through: none"> </TD><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl68 style="BORDER-RIGHT: #969696 0.5pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl66 style="BORDER-RIGHT: gray 0.5pt solid; BORDER-TOP: gray 0.5pt solid; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BORDER-LEFT: gray 0.5pt solid; COLOR: white; BORDER-BOTTOM: gray 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: transparent; TEXT-DECORATION: none; mso-background-source: auto; mso-pattern: auto; text-underline-style: none; text-line-through: none"> </TD><TD class=xl69 style="BORDER-RIGHT: windowtext 1pt solid; BORDER-TOP: gray; BORDER-LEFT: #969696 0.5pt solid; BORDER-BOTTOM: gray 0.5pt solid; BACKGROUND-COLOR: transparent"> </TD><TD class=xl72 style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; BACKGROUND-COLOR: transparent" align=right>13.4%</TD></TR></TBODY></TABLE>

I hope i was clear with my explanations.
thank you a lot.

 

[AlphaFrog]

<br /><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th><th>J</th><th>K</th><th>L</th><th>M</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">JANUARY</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">FEBRUARY</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">MARCH</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">APRIL</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">MAY</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">JUNE</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">JULY</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">AUGUST</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">SEPTEMBER</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">OCTOBER</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">NOVEMBER</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">DECEMBER</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-left: 1px solid black;;">TOTALS</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">31.60%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">31.60%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">31.60%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">31.60%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">20.90%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">20.90%</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">37.20%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">37.20%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">37.20%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">37.20%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">26.70%</td><td style="font-weight: bold;text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">26.70%</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13.60%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13.60%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13.60%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13.60%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">11.90%</td><td style="font-weight: bold;text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">11.90%</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12.20%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12.20%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12.20%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">12.20%</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13.40%</td><td style="font-weight: bold;text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="font-weight: bold;text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #FFFFFF;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">13.40%</td></tr></tbody></table><br /><br /><table cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M2</th><td style="text-align:left">=INDEX(<font color="Blue">A2:L2,1,COUNTA(<font color="Red">A2:L2</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M3</th><td style="text-align:left">=INDEX(<font color="Blue">A3:L3,1,COUNTA(<font color="Red">A3:L3</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M4</th><td style="text-align:left">=INDEX(<font color="Blue">A4:L4,1,COUNTA(<font color="Red">A4:L4</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">M5</th><td style="text-align:left">=INDEX(<font color="Blue">A5:L5,1,COUNTA(<font color="Red">A5:L5</font>)</font>)</td></tr></tbody></table></td></tr></table><br />

 

[VBACO]

Its ugly but it works.

=IF(ISBLANK(I3),IF(ISBLANK(H3),IF(ISBLANK(G3),IF(ISBLANK(F3),IF(ISBLANK(E3),IF(ISBLANK(D3),IF(ISBLANK(C3),IF(ISBLANK(B3),IF(ISBLANK(A3),,A3),B3),C3),D3),E3),F3),G3),H3),I3)

 

[VBACO]

Well done Alpha, yours is way better.

 

[jevi]

Guys thank you so much. That is very kind and I love this forum as there is always an answer and fast. I wish sometimes I was helpful to the others .

Still while going through to some others threds just for reading i found also my answer which was close to mine and I figure it out:

=lookup(9.999E+307,F50:Q50) and it worked great so you have the last value .


have a nice day,
Jevi

 

[AlphaFrog]

If your monthly percents don't go above 100%, you could use

=LOOKUP(2,F50:Q50)

 

[jevi]

yes the % doesn't go higher than 100 but i have some other data in value and there it doesnt work. N/A.

Still, is good to know that there are a lot of options when I didn't know any of them!