help to analysis election results polling booth wise

a130368

New Member
Joined
Mar 5, 2012
Messages
1
i have to compare election results for same consituancy area for different elections held,which means i have to compare for each polling booth.i have my data in different sheets like this
<table width="1236" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:101pt" span="2" width="135"> <col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> <col style="width:101pt" width="135"> <col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="mso-width-source:userset;mso-width-alt:2523;width:52pt" width="69"> <col style="mso-width-source:userset;mso-width-alt:2194;width:45pt" width="60"> <col style="mso-width-source:userset;mso-width-alt:2962;width:61pt" width="81"> <col style="mso-width-source:userset;mso-width-alt:2157; width:44pt" span="2" width="59"> <col style="mso-width-source:userset;mso-width-alt:1828;width:38pt" width="50"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:2230;width:46pt" width="61"> <col style="mso-width-source:userset;mso-width-alt:2011;width:41pt" width="55"> <col style="mso-width-source:userset;mso-width-alt:1938;width:40pt" width="53"> <col style="mso-width-source:userset;mso-width-alt:2560;width:53pt" width="70"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl64" style="height:15.0pt;width:101pt" width="135" height="20">vs name</td> <td class="xl64" style="border-left:none;width:101pt" width="135">election</td> <td class="xl65" style="border-left:none;width:68pt" width="90">pol. Booth no.</td> <td class="xl64" style="border-left:none;width:101pt" width="135">poling booth detail</td> <td class="xl66" style="border-left:none;width:53pt" width="71">BJP</td> <td class="xl66" style="border-left:none;width:52pt" width="69">CPM</td> <td class="xl66" style="border-left:none;width:45pt" width="60">BSP</td> <td class="xl66" style="border-left:none;width:61pt" width="81">INC</td> <td class="xl66" style="border-left:none;width:44pt" width="59">SHS</td> <td class="xl66" style="border-left:none;width:44pt" width="59">JD (U)</td> <td class="xl66" style="border-left:none;width:38pt" width="50">GGP</td> <td class="xl66" style="border-left:none;width:40pt" width="53">BJSH</td> <td class="xl66" style="border-left:none;width:46pt" width="61">RSMD</td> <td class="xl66" style="border-left:none;width:41pt" width="55">GMS</td> <td class="xl66" style="border-left:none;width:40pt" width="53">IND</td> <td class="xl66" style="border-left:none;width:53pt" width="70">total</td> </tr> <tr style="height:18.75pt" height="25"> <td class="xl64" style="height:18.75pt;border-top:none" height="25">patan 95</td> <td class="xl64" style="border-top:none;border-left:none">vs 08</td> <td class="xl67" style="border-top:none;border-left:none">1</td> <td class="xl68" style="border-top:none;border-left:none">poudikala</td> <td class="xl65" style="border-top:none;border-left:none" align="right">295</td> <td class="xl65" style="border-top:none;border-left:none" align="right">4</td> <td class="xl69" style="border-top:none;border-left:none">12</td> <td class="xl69" style="border-top:none;border-left:none">105</td> <td class="xl69" style="border-top:none;border-left:none">8</td> <td class="xl65" style="border-top:none;border-left:none" align="right">1</td> <td class="xl65" style="border-top:none;border-left:none" align="right">8</td> <td class="xl65" style="border-top:none;border-left:none" align="right">5</td> <td class="xl65" style="border-top:none;border-left:none" align="right">2</td> <td class="xl65" style="border-top:none;border-left:none" align="right">3</td> <td class="xl65" style="border-top:none;border-left:none" align="right">26</td> <td class="xl65" style="border-top:none;border-left:none" align="right">469</td> </tr> <tr style="height:18.75pt" height="25"> <td class="xl64" style="height:18.75pt;border-top:none" height="25">patan 95</td> <td class="xl64" style="border-top:none;border-left:none">vs 08</td> <td class="xl67" style="border-top:none;border-left:none">2</td> <td class="xl68" style="border-top:none;border-left:none">poudikhurd</td> <td class="xl65" style="border-top:none;border-left:none" align="right">103</td> <td class="xl65" style="border-top:none;border-left:none" align="right">2</td> <td class="xl69" style="border-top:none;border-left:none">3</td> <td class="xl69" style="border-top:none;border-left:none">105</td> <td class="xl69" style="border-top:none;border-left:none">4</td> <td class="xl65" style="border-top:none;border-left:none" align="right">0</td> <td class="xl65" style="border-top:none;border-left:none" align="right">28</td> <td class="xl65" style="border-top:none;border-left:none" align="right">0</td> <td class="xl65" style="border-top:none;border-left:none" align="right">3</td> <td class="xl65" style="border-top:none;border-left:none" align="right">3</td> <td class="xl65" style="border-top:none;border-left:none" align="right">13</td> <td class="xl65" style="border-top:none;border-left:none" align="right">264</td> </tr> <tr style="height:18.75pt" height="25"> <td class="xl64" style="height:18.75pt;border-top:none" height="25">patan 95</td> <td class="xl64" style="border-top:none;border-left:none">vs 08</td> <td class="xl67" style="border-top:none;border-left:none">3</td> <td class="xl68" style="border-top:none;border-left:none">malakhurd</td> <td class="xl65" style="border-top:none;border-left:none" align="right">84</td> <td class="xl65" style="border-top:none;border-left:none" align="right">3</td> <td class="xl69" style="border-top:none;border-left:none">18</td> <td class="xl69" style="border-top:none;border-left:none">279</td> <td class="xl69" style="border-top:none;border-left:none">12</td> <td class="xl65" style="border-top:none;border-left:none" align="right">1</td> <td class="xl65" style="border-top:none;border-left:none" align="right">3</td> <td class="xl65" style="border-top:none;border-left:none" align="right">3</td> <td class="xl65" style="border-top:none;border-left:none" align="right">1</td> <td class="xl65" style="border-top:none;border-left:none" align="right">13</td> <td class="xl65" style="border-top:none;border-left:none" align="right">27</td> <td class="xl65" style="border-top:none;border-left:none" align="right">444</td> </tr> <tr style="height:18.75pt" height="25"> <td class="xl64" style="height:18.75pt;border-top:none" height="25">patan 95</td> <td class="xl64" style="border-top:none;border-left:none">vs 08</td> <td class="xl67" style="border-top:none;border-left:none">4</td> <td class="xl68" style="border-top:none;border-left:none">malakala</td> <td class="xl65" style="border-top:none;border-left:none" align="right">254</td> <td class="xl65" style="border-top:none;border-left:none" align="right">9</td> <td class="xl69" style="border-top:none;border-left:none">13</td> <td class="xl69" style="border-top:none;border-left:none">191</td> <td class="xl69" style="border-top:none;border-left:none">3</td> <td class="xl65" style="border-top:none;border-left:none" align="right">1</td> <td class="xl65" style="border-top:none;border-left:none" align="right">4</td> <td class="xl65" style="border-top:none;border-left:none" align="right">5</td> <td class="xl65" style="border-top:none;border-left:none" align="right">2</td> <td class="xl65" style="border-top:none;border-left:none" align="right">6</td> <td class="xl65" style="border-top:none;border-left:none" align="right">32</td> <td class="xl65" style="border-top:none;border-left:none" align="right">520</td> </tr> <tr style="height:18.75pt" height="25"> <td class="xl64" style="height:18.75pt;border-top:none" height="25">patan 95</td> <td class="xl64" style="border-top:none;border-left:none">vs 08</td> <td class="xl67" style="border-top:none;border-left:none">5</td> <td class="xl68" style="border-top:none;border-left:none">poudi hardua</td> <td class="xl65" style="border-top:none;border-left:none" align="right">169</td> <td class="xl65" style="border-top:none;border-left:none" align="right">2</td> <td class="xl69" style="border-top:none;border-left:none">28</td> <td class="xl69" style="border-top:none;border-left:none">418</td> <td class="xl69" style="border-top:none;border-left:none">10</td> <td class="xl65" style="border-top:none;border-left:none" align="right">2</td> <td class="xl65" style="border-top:none;border-left:none" align="right">4</td> <td class="xl65" style="border-top:none;border-left:none" align="right">3</td> <td class="xl65" style="border-top:none;border-left:none" align="right">4</td> <td class="xl65" style="border-top:none;border-left:none" align="right">14</td> <td class="xl65" style="border-top:none;border-left:none" align="right">37</td> <td class="xl65" style="border-top:none;border-left:none" align="right">691</td> </tr> </tbody></table>this is one sample sheet,like this i have many sheets for different constituency as well as different elections .i want my comparison in this type of format
<table width="1137" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="width:48pt" span="3" width="64"> <col style="mso-width-source:userset;mso-width-alt:6473;width:133pt" width="177"> <col style="width:48pt" span="12" width="64"> </colgroup><tbody><tr style="height:15.0pt" height="20"> <td class="xl66" style="height:15.0pt;width:48pt" width="64" height="20">vs name</td> <td class="xl66" style="border-left:none;width:48pt" width="64">election</td> <td class="xl67" style="border-left:none;width:48pt" width="64">pol. Booth no.</td> <td class="xl66" style="border-left:none;width:133pt" width="177">poling booth detail</td> <td class="xl68" style="border-left:none;width:48pt" width="64">BJP</td> <td class="xl68" style="border-left:none;width:48pt" width="64">CPM</td> <td class="xl68" style="border-left:none;width:48pt" width="64">BSP</td> <td class="xl68" style="border-left:none;width:48pt" width="64">INC</td> <td class="xl68" style="border-left:none;width:48pt" width="64">SHS</td> <td class="xl68" style="border-left:none;width:48pt" width="64">JD (U)</td> <td class="xl68" style="border-left:none;width:48pt" width="64">GGP</td> <td class="xl68" style="border-left:none;width:48pt" width="64">BJSH</td> <td class="xl68" style="border-left:none;width:48pt" width="64">RSMD</td> <td class="xl68" style="border-left:none;width:48pt" width="64">GMS</td> <td class="xl68" style="border-left:none;width:48pt" width="64">IND</td> <td class="xl68" style="border-left:none;width:48pt" width="64">total</td> </tr> <tr style="height:18.75pt" height="25"> <td class="xl66" style="height:18.75pt;border-top:none" height="25">patan 95</td> <td class="xl66" style="border-top:none;border-left:none">vs 08</td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl71" style="border-top:none;border-left:none">poudikala</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="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="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:18.75pt" height="25"> <td class="xl66" style="height:18.75pt;border-top:none" height="25">patan 95</td> <td class="xl66" style="border-top:none;border-left:none">vs 03</td> <td class="xl69" style="border-top:none;border-left:none">1</td> <td class="xl71" style="border-top:none;border-left:none">poudikala</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="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="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:18.75pt" height="25"> <td class="xl66" style="height:18.75pt;border-top:none" height="25">bargi 96</td> <td class="xl66" style="border-top:none;border-left:none">vs 98</td> <td class="xl69" style="border-top:none;border-left:none">23</td> <td class="xl71" style="border-top:none;border-left:none">poudikala</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="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="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:18.75pt" height="25"> <td class="xl66" style="height:18.75pt;border-top:none" height="25">patan 95</td> <td class="xl66" style="border-top:none;border-left:none">vs 08</td> <td class="xl69" style="border-top:none;border-left:none">4</td> <td class="xl71" style="border-top:none;border-left:none">poudikhurd</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="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="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:18.75pt" height="25"> <td class="xl66" style="height:18.75pt;border-top:none" height="25">patan 95</td> <td class="xl66" style="border-top:none;border-left:none">vs 03</td> <td class="xl69" style="border-top:none;border-left:none">5</td> <td class="xl71" style="border-top:none;border-left:none">poudikhurd</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="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="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:18.75pt" height="25"> <td class="xl66" style="height:18.75pt;border-top:none" height="25">bargi 96</td> <td class="xl66" style="border-top:none;border-left:none">vs 98</td> <td class="xl69" style="border-top:none;border-left:none">54</td> <td class="xl71" style="border-top:none;border-left:none">poudikhurd

</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> </tbody></table>so all the data relating one polling booth should fall in a single place for different years.i can not compare by matching columns as in each election polling booths shifts to a new constituency,so their order is different too.
i am using excel 2010 on windows 7.
<table style="width: 947px; height: 193px;" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height:18.75pt" height="25"><td class="xl70" 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="xl69" style="border-top:none;border-left:none">
</td><td class="xl69" style="border-top:none;border-left:none">
</td><td class="xl69" 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:18.75pt" height="25"> <td class="xl70" 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="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" 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:18.75pt" height="25"> <td class="xl70" 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="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" 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:18.75pt" height="25"> <td class="xl70" 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="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" style="border-top:none;border-left:none">
</td> <td class="xl69" 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:18.75pt" height="25"> <td class="xl70" 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> </tbody></table>
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

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