I have the following:
<b>Excel 2007</b><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 /></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></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store Name</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store 1 Visits</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store 1 Sales</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store Sale %</td><td style="font-weight: bold;background-color: #DBE5F1;;">Max Store 1 Sales</td><td style="font-weight: bold;background-color: #DBE5F1;;">% of Max store 1 sales</td><td style="font-weight: bold;background-color: #DBE5F1;;">Store 1 Sale without Max</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store 2 Visits</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store 2 Sales</td><td style="font-weight: bold;background-color: #DBE5F1;;">Store 2 Sale%</td><td style="font-weight: bold;background-color: #DBE5F1;;">Sale Change</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="border-top: 1px solid black;background-color: #FFFF00;;">Macys</td><td style="text-align: right;border-top: 1px solid black;background-color: #FFFF00;;">127672</td><td style="text-align: right;border-top: 1px solid black;background-color: #FFFF00;;">1544</td><td style="text-align: right;border-top: 1px solid black;background-color: #FFFF00;;">1.20961%</td><td style="text-align: right;;">1531</td><td style="text-align: right;;">99%</td><td style="text-align: right;;"></td><td style="text-align: right;border-top: 1px solid black;background-color: #FFFF00;;">10133890</td><td style="text-align: right;border-top: 1px solid black;background-color: #FFFF00;;">6185</td><td style="text-align: right;background-color: #FFFF00;;">0.06103%</td><td style="text-align: right;background-color: #FFFF00;;">1882%</td></tr></tbody></table><p style="width:7.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Best Profiles</p><br /><br />
I am comparing store 1 to store 2. in column E I have the max sales of store 1. I want to find Column G, what is the sale % of the rest of the store without that max sale? I have the following on another sheet:
<b>Excel 2007</b><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 /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>E</th><th>F</th><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Store 1 Name</td><td style=";">City</td><td style=";">Store Visits</td><td style=";">Store Sales</td></tr><tr ><td style="color: #161120;text-align: center;">1891</td><td style=";">Macys</td><td style=";">NYC</td><td style="text-align: right;;">3283.333201</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">1896</td><td style=";">Macys</td><td style=";">DC</td><td style="text-align: right;;">14409.99998</td><td style="text-align: right;;">4.5</td></tr><tr ><td style="color: #161120;text-align: center;">1907</td><td style=";">Macys</td><td style=";">SF</td><td style="text-align: right;;">129</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">2010</td><td style=";">Macys</td><td style=";">LA</td><td style="text-align: right;;">4105</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">2011</td><td style=";">Macys</td><td style=";">Boston</td><td style="text-align: right;;">178</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">2015</td><td style=";">Macys</td><td style=";">Chicago</td><td style="text-align: right;;">67562.5</td><td style="text-align: right;;">1531</td></tr><tr ><td style="color: #161120;text-align: center;">2236</td><td style=";">Macys</td><td style=";">Atlanta</td><td style="text-align: right;;">11768</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">2513</td><td style=";">Macys</td><td style=";">Houston</td><td style="text-align: right;;">17974</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">2518</td><td style=";">Macys</td><td style=";">Dallas</td><td style="text-align: right;;">8262.333098</td><td style="text-align: right;;">4.833299994</td></tr></tbody></table><p style="width:2.4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Data</p><br /><br />
As you can see, the max refers to the Chicago Macys but I want the sale% from the other cities so that way I can compare if the other stores are doing as good as that store with the most sales. Sale % = store sale/store visit.
<b>Excel 2007</b><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 /></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></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store Name</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store 1 Visits</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store 1 Sales</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store Sale %</td><td style="font-weight: bold;background-color: #DBE5F1;;">Max Store 1 Sales</td><td style="font-weight: bold;background-color: #DBE5F1;;">% of Max store 1 sales</td><td style="font-weight: bold;background-color: #DBE5F1;;">Store 1 Sale without Max</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store 2 Visits</td><td style="font-weight: bold;border-bottom: 1px solid black;background-color: #DBE5F1;;">Store 2 Sales</td><td style="font-weight: bold;background-color: #DBE5F1;;">Store 2 Sale%</td><td style="font-weight: bold;background-color: #DBE5F1;;">Sale Change</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="border-top: 1px solid black;background-color: #FFFF00;;">Macys</td><td style="text-align: right;border-top: 1px solid black;background-color: #FFFF00;;">127672</td><td style="text-align: right;border-top: 1px solid black;background-color: #FFFF00;;">1544</td><td style="text-align: right;border-top: 1px solid black;background-color: #FFFF00;;">1.20961%</td><td style="text-align: right;;">1531</td><td style="text-align: right;;">99%</td><td style="text-align: right;;"></td><td style="text-align: right;border-top: 1px solid black;background-color: #FFFF00;;">10133890</td><td style="text-align: right;border-top: 1px solid black;background-color: #FFFF00;;">6185</td><td style="text-align: right;background-color: #FFFF00;;">0.06103%</td><td style="text-align: right;background-color: #FFFF00;;">1882%</td></tr></tbody></table><p style="width:7.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Best Profiles</p><br /><br />
I am comparing store 1 to store 2. in column E I have the max sales of store 1. I want to find Column G, what is the sale % of the rest of the store without that max sale? I have the following on another sheet:
<b>Excel 2007</b><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 /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>E</th><th>F</th><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Store 1 Name</td><td style=";">City</td><td style=";">Store Visits</td><td style=";">Store Sales</td></tr><tr ><td style="color: #161120;text-align: center;">1891</td><td style=";">Macys</td><td style=";">NYC</td><td style="text-align: right;;">3283.333201</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">1896</td><td style=";">Macys</td><td style=";">DC</td><td style="text-align: right;;">14409.99998</td><td style="text-align: right;;">4.5</td></tr><tr ><td style="color: #161120;text-align: center;">1907</td><td style=";">Macys</td><td style=";">SF</td><td style="text-align: right;;">129</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">2010</td><td style=";">Macys</td><td style=";">LA</td><td style="text-align: right;;">4105</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">2011</td><td style=";">Macys</td><td style=";">Boston</td><td style="text-align: right;;">178</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">2015</td><td style=";">Macys</td><td style=";">Chicago</td><td style="text-align: right;;">67562.5</td><td style="text-align: right;;">1531</td></tr><tr ><td style="color: #161120;text-align: center;">2236</td><td style=";">Macys</td><td style=";">Atlanta</td><td style="text-align: right;;">11768</td><td style="text-align: right;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">2513</td><td style=";">Macys</td><td style=";">Houston</td><td style="text-align: right;;">17974</td><td style="text-align: right;;">1</td></tr><tr ><td style="color: #161120;text-align: center;">2518</td><td style=";">Macys</td><td style=";">Dallas</td><td style="text-align: right;;">8262.333098</td><td style="text-align: right;;">4.833299994</td></tr></tbody></table><p style="width:2.4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Data</p><br /><br />
As you can see, the max refers to the Chicago Macys but I want the sale% from the other cities so that way I can compare if the other stores are doing as good as that store with the most sales. Sale % = store sale/store visit.
