Formula to evaluate alternate columns when a row contains multiples of a value

B

Benzoli7

Board Regular
Joined
Jan 11, 2010
Messages
136
Can anyone help me with a formula? I have the data set below. Currently I am using this formula in Column A to determine which vendor offers the largest discount (DISC).

=INDEX($G$1:$N$1,1,MATCH(MAX(G3,I3,K3,M3,O3),G3:O3,0))

The only problem is that when multiple vendors offer the same largest discount, I need to look for the lowest value in the MC column associated with one of the vendors with the largest discount.

I apologize for the data below being awkward. Columns A:C contain the analysis. Columns G:N contain the data. Columns D:F are blank.

Thanks so much for your help.



<table style="width: 579px; height: 248px;" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" span="14" width="64"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td colspan="3" class="xl65" style="height:15.0pt;width:144pt" height="20" width="192"> <table border="0" cellpadding="0" cellspacing="0" width="896"><colgroup><col style="width:48pt" span="14" width="64"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td colspan="3" class="xl65" style="height:15.0pt;width:144pt" height="20" width="192">Vendor Solution (Buy)</td> <td colspan="2" class="xl65" style="border-left:none;width:96pt" width="128">
</td> <td class="xl72" style="border-left:none;width:48pt" width="64">
</td> <td colspan="2" class="xl66" style="border-left:none;width:96pt" width="128">Red</td> <td colspan="2" class="xl66" style="border-left:none;width:96pt" width="128">Blue</td> <td colspan="2" class="xl66" style="border-left:none;width:96pt" width="128">Green</td> <td colspan="2" class="xl66" style="border-left:none;width:96pt" width="128">Yellow</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">

Vendor </td> <td class="xl67" style="border-top:none;border-left:none"> Disc </td> <td class="xl67" style="border-top:none;border-left:none"> MC </td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none"> Disc </td> <td class="xl67" style="border-top:none;border-left:none"> MC </td> <td class="xl67" style="border-top:none;border-left:none"> Disc </td> <td class="xl67" style="border-top:none;border-left:none"> MC </td> <td class="xl67" style="border-top:none;border-left:none"> Disc </td> <td class="xl67" style="border-top:none;border-left:none"> MC </td> <td class="xl67" style="border-top:none;border-left:none"> Disc </td> <td class="xl67" style="border-top:none;border-left:none"> MC </td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Blue</td> <td class="xl69" style="border-top:none;border-left:none" align="right">73.0%</td> <td class="xl70" style="border-top:none;border-left:none">60</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.68</td> <td class="xl71" style="border-top:none;border-left:none">52.00</td> <td class="xl71" style="border-top:none;border-left:none">0.73</td> <td class="xl71" style="border-top:none;border-left:none">60.00</td> <td class="xl71" style="border-top:none;border-left:none">0.60</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">0.73</td> <td class="xl71" style="border-top:none;border-left:none">53.00</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Blue</td> <td class="xl69" style="border-top:none;border-left:none" align="right">71.5%</td> <td class="xl70" style="border-top:none;border-left:none">65</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.68</td> <td class="xl71" style="border-top:none;border-left:none">60.00</td> <td class="xl71" style="border-top:none;border-left:none">0.72</td> <td class="xl71" style="border-top:none;border-left:none">65.00</td> <td class="xl71" style="border-top:none;border-left:none">0.63</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Blue</td> <td class="xl69" style="border-top:none;border-left:none" align="right">73.0%</td> <td class="xl70" style="border-top:none;border-left:none">77</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.73</td> <td class="xl71" style="border-top:none;border-left:none">77.00</td> <td class="xl71" style="border-top:none;border-left:none">0.66</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Blue</td> <td class="xl69" style="border-top:none;border-left:none" align="right">73.0%</td> <td class="xl70" style="border-top:none;border-left:none">77</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.73</td> <td class="xl71" style="border-top:none;border-left:none">77.00</td> <td class="xl71" style="border-top:none;border-left:none">0.66</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Blue</td> <td class="xl69" style="border-top:none;border-left:none" align="right">73.0%</td> <td class="xl70" style="border-top:none;border-left:none">77</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.73</td> <td class="xl71" style="border-top:none;border-left:none">77.00</td> <td class="xl71" style="border-top:none;border-left:none">0.66</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Green</td> <td class="xl69" style="border-top:none;border-left:none" align="right">66.0%</td> <td class="xl70" style="border-top:none;border-left:none">76.5</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.65</td> <td class="xl71" style="border-top:none;border-left:none">88.50</td> <td class="xl71" style="border-top:none;border-left:none">0.66</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Blue</td> <td class="xl69" style="border-top:none;border-left:none" align="right">71.5%</td> <td class="xl70" style="border-top:none;border-left:none">69</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.72</td> <td class="xl71" style="border-top:none;border-left:none">69.00</td> <td class="xl71" style="border-top:none;border-left:none">0.68</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Green</td> <td class="xl69" style="border-top:none;border-left:none" align="right">68.0%</td> <td class="xl70" style="border-top:none;border-left:none">76.5</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.65</td> <td class="xl71" style="border-top:none;border-left:none">88.50</td> <td class="xl71" style="border-top:none;border-left:none">0.68</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Blue</td> <td class="xl69" style="border-top:none;border-left:none" align="right">71.5%</td> <td class="xl70" style="border-top:none;border-left:none">69</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.72</td> <td class="xl71" style="border-top:none;border-left:none">69.00</td> <td class="xl71" style="border-top:none;border-left:none">0.68</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Red</td> <td class="xl69" style="border-top:none;border-left:none" align="right">68.0%</td> <td class="xl70" style="border-top:none;border-left:none">60</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.68</td> <td class="xl71" style="border-top:none;border-left:none">60.00</td> <td class="xl71" style="border-top:none;border-left:none">0.65</td> <td class="xl71" style="border-top:none;border-left:none">88.50</td> <td class="xl71" style="border-top:none;border-left:none">0.61</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Red</td> <td class="xl69" style="border-top:none;border-left:none" align="right">68.0%</td> <td class="xl70" style="border-top:none;border-left:none">60</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.68</td> <td class="xl71" style="border-top:none;border-left:none">60.00</td> <td class="xl71" style="border-top:none;border-left:none">0.25</td> <td class="xl71" style="border-top:none;border-left:none">199.00</td> <td class="xl71" style="border-top:none;border-left:none">0.61</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">Blue</td> <td class="xl69" style="border-top:none;border-left:none" align="right">73.0%</td> <td class="xl70" style="border-top:none;border-left:none">60</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">0.68</td> <td class="xl71" style="border-top:none;border-left:none">60.00</td> <td class="xl71" style="border-top:none;border-left:none">0.73</td> <td class="xl71" style="border-top:none;border-left:none">60.00</td> <td class="xl71" style="border-top:none;border-left:none">0.60</td> <td class="xl71" style="border-top:none;border-left:none">76.50</td> <td class="xl71" style="border-top:none;border-left:none">0.73</td> <td class="xl71" style="border-top:none;border-left:none">53.00</td> </tr> </tbody></table></td> <td colspan="2" class="xl65" style="border-left:none;width:96pt" width="128">
</td> <td class="xl72" style="border-left:none;width:48pt" width="64">
</td> <td colspan="2" class="xl66" style="border-left:none;width:96pt" width="128">
</td> <td colspan="2" class="xl66" style="border-left:none;width:96pt" width="128">
</td> <td colspan="2" class="xl66" style="border-left:none;width:96pt" width="128">
</td> <td colspan="2" class="xl66" style="border-left:none;width:96pt" width="128">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl67" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> <td class="xl67" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> <tr style="height:15.0pt" height="20"> <td class="xl68" style="height:15.0pt;border-top:none" height="20">
</td> <td class="xl69" style="border-top:none;border-left:none" align="right">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl70" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> <td class="xl71" style="border-top:none;border-left:none">
</td> </tr> </tbody></table>
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
You must log in or register to reply here.

Similar threads

D
  • Solved
VBA Function to Paste Table into Outlook Email Resulting in HTML language in Email
Replies
8
Views
622
smozgur
smozgur
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
2K
CrashOD
C
M
  • Question Question
Build HTML Table based on Loop through Excel Worksheet Column / Row condition
Replies
0
Views
945
mystik5
M
N
  • Question Question
INDEX MATCH duplicate value issues
Replies
3
Views
1K
newbie37
N
R
  • Question Question
Concatenate dynamic Column values with column header
Replies
2
Views
927
rockyboy
R

Forum statistics

Threads
1,224,586
Messages
6,179,718
Members
452,939
Latest member
WCrawford

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