Hi,
I need help, what is the best excel formula should I use to get the data as a Result. Please help. Thanks.
[TABLE="width: 179"]
<TBODY>[TR]
[TD][TABLE="width: 179"]
<TBODY>[TR]
[TD][TABLE="width: 321"]
<COLGROUP><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: 2852" width=78><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" width=64><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><TBODY>[TR]
[TD="class: xl73, width: 100, bgcolor: transparent"]Original Data[/TD]
[TD="class: xl73, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl73, width: 90, bgcolor: transparent"]Result[/TD]
[TD="class: xl65, width: 95, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #ff9900"]Corporate[/TD]
[TD="class: xl67, bgcolor: #ff9900"]Total[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #ff9900"]Corporate[/TD]
[TD="class: xl67, bgcolor: #ff9900"]Total[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]COMPANY A[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]COMPANY A[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]360[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]ABC[/TD]
[TD="class: xl71, bgcolor: transparent"]360.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]COMPANY B[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]135[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]360.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]COMPANY C[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]65[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]COMPANY B[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]COMPANY D[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]120[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]CDE[/TD]
[TD="class: xl71, bgcolor: transparent"]30.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]ABC[/TD]
[TD="class: xl71, bgcolor: transparent"]75.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]FGH[/TD]
[TD="class: xl71, bgcolor: transparent"]30.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]135.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]COMPANY C[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]IJK[/TD]
[TD="class: xl71, bgcolor: transparent"]65.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]65.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]COMPANY D[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]LMN[/TD]
[TD="class: xl71, bgcolor: transparent"]60.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]IJK[/TD]
[TD="class: xl71, bgcolor: transparent"]60.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]120.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD]</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL></COLGROUP>[/TABLE]
[/TD]
[TD]</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL></COLGROUP>[/TABLE]
I need help, what is the best excel formula should I use to get the data as a Result. Please help. Thanks.
[TABLE="width: 179"]
<TBODY>[TR]
[TD][TABLE="width: 179"]
<TBODY>[TR]
[TD][TABLE="width: 321"]
<COLGROUP><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: 2852" width=78><COL style="WIDTH: 48pt; mso-width-source: userset; mso-width-alt: 2340" width=64><COL style="WIDTH: 68pt; mso-width-source: userset; mso-width-alt: 3291" width=90><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3474" width=95><TBODY>[TR]
[TD="class: xl73, width: 100, bgcolor: transparent"]Original Data[/TD]
[TD="class: xl73, width: 78, bgcolor: transparent"][/TD]
[TD="class: xl73, width: 64, bgcolor: transparent"][/TD]
[TD="class: xl73, width: 90, bgcolor: transparent"]Result[/TD]
[TD="class: xl65, width: 95, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: #ff9900"]Corporate[/TD]
[TD="class: xl67, bgcolor: #ff9900"]Total[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl66, bgcolor: #ff9900"]Corporate[/TD]
[TD="class: xl67, bgcolor: #ff9900"]Total[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]COMPANY A[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]COMPANY A[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]360[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]ABC[/TD]
[TD="class: xl71, bgcolor: transparent"]360.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]COMPANY B[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]135[/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]360.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]COMPANY C[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]65[/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]COMPANY B[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl68, bgcolor: transparent"]COMPANY D[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]120[/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]CDE[/TD]
[TD="class: xl71, bgcolor: transparent"]30.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]ABC[/TD]
[TD="class: xl71, bgcolor: transparent"]75.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]FGH[/TD]
[TD="class: xl71, bgcolor: transparent"]30.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]135.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]COMPANY C[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]IJK[/TD]
[TD="class: xl71, bgcolor: transparent"]65.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]65.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]COMPANY D[/TD]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]LMN[/TD]
[TD="class: xl71, bgcolor: transparent"]60.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl70, bgcolor: transparent"]IJK[/TD]
[TD="class: xl71, bgcolor: transparent"]60.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: transparent"][/TD]
[TD="class: xl72, bgcolor: transparent"]120.00[/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[TD="class: xl65, bgcolor: transparent"][/TD]
[/TR]
</TBODY>[/TABLE]
[/TD]
[TD]</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL></COLGROUP>[/TABLE]
[/TD]
[TD]</SPAN>[/TD]
[/TR]
</TBODY><COLGROUP><COL><COL></COLGROUP>[/TABLE]