Excel小問題,如何用公式條件取代樞紐分析表?(20點) - 工作
By Zenobia
at 2011-10-08T00:00
at 2011-10-08T00:00
Table of Contents
問題一:各組別某到職年度在某年度升遷幾人?(sheet1)1職位組別升遷年度到職年度2經理A1組201120013副理A1組201020054副理A2組201120065組長A2組201020086副理A3組201020057經理A3組201120028副理A3組201120069組長A6組2009200710組長A6組2010200611組長A6組20102007(sheet2)1職位組別升遷年度到職年度2組長A1組201120073組長A1組201020074組長A1組201120085副理A2組201020046經理A2組201020027經理A2組201120028副理A3組201120049副理A3組2009200510副理A6組2010200511經理A6組20102001過去用樞紐分析表,上圖兩個sheet�
Tags:
工作
All Comments
By Selena
at 2011-10-12T18:09
at 2011-10-12T18:09
By Vanessa
at 2011-10-09T14:48
at 2011-10-09T14:48
Related Posts
因公受傷的定義
By Blanche
at 2011-10-07T00:00
at 2011-10-07T00:00
麥當勞的排班好少怎麼辦:(
By Regina
at 2011-10-07T00:00
at 2011-10-07T00:00
gogobox下載轉跳後會出現無發取得檔案請稍後再試的視窗
By Anonymous
at 2011-10-07T00:00
at 2011-10-07T00:00
30好幾了工作似乎沒前途,廣告勿來.
By Dinah
at 2011-10-07T00:00
at 2011-10-07T00:00
命盤討論合夥創業適合性,能否賺錢?
By Kristin
at 2011-10-07T00:00
at 2011-10-07T00:00