[求助]大哥大姐帮帮我的怪问题

anff · 发表于 2008-9-10 10:44

这是个退养时间表，我怎么能快速统计出某年一共有多少人退休的呢，分别是哪些地方的呢。表的C列是正式退休时间,这只是一个工作表，一共有10多个工作表，要统计道一块，怎么统计，谢谢啊。<table bordercolor="#cccccc" cellspacing="2" cellpadding="3" width="100%" bgcolor="#ffffff" border="1"><tbody><tr><td> a                         b                     c<table cellspacing="0" cellpadding="0" width="351" border="0" style="WIDTH: 264pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="94" style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3008;"></col><col></col><col width="97" style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3104;"></col><col></col><col width="88" style="WIDTH: 66pt; mso-width-source: userset; mso-width-alt: 2816;"></col><col></col><col width="72" style="WIDTH: 54pt;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td width="94" height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; WIDTH: 71pt; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000259</td><td class="xl25" width="97" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; WIDTH: 73pt; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-12-26</td><td class="xl25" width="88" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; WIDTH: 66pt; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2008-1-1</td><td width="72" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; WIDTH: 54pt; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同市区</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000224</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-2-14</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2008-5-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">北京</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000231</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-2-14</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2008-10-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同县城</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000235</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-2-14</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2008-10-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同市区</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000244</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-4-9</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2009-3-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同市区</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000260</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-2-14</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2009-4-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同市区</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000264</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-2-14</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2009-4-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同天镇</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000234</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-5-6</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2009-7-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同市区</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000227</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-6-1</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2010-4-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同浑源</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000242</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-2-14</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2010-7-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同市区</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000226</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2002-3-7</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2010-9-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同市区</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000251</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2002-3-7</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2010-10-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同市区</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000247</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-2-14</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2011-8-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同市区</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000246</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-2-14</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2012-3-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同市区</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000228</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-5-20</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2012-4-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同广灵</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000248</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-2-14</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2012-11-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同广灵</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td height="19" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">4101000236</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2001-2-10</td><td class="xl25" style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">2012-12-1</td><td style="BORDER-RIGHT: #f3f5f7; BORDER-TOP: #f3f5f7; BORDER-LEFT: #f3f5f7; BORDER-BOTTOM: #f3f5f7; BACKGROUND-COLOR: transparent;">大同左云</td></tr></tbody></table></td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr><tr><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr></tbody></table>

[此贴子已经被作者于2008-9-10 11:17:13编辑过]

zez · 发表于 2008-9-10 10:54

表在哪里？

york888 · 发表于 2008-9-11 10:34

上传附件!

		自动登录	找回密码
密码			免费注册