請問在EXCEL中如何選出每週的最高數值 - 工作
By Connor
at 2010-11-19T00:00
at 2010-11-19T00:00
Table of Contents
表格如下....我想求每週工作日數值的最大值........A...............B.........C1......日期..........星期.....數值2.....2010/9/13......1.........563.....2010/9/14......2.........774.....2010/9/15......3.........455.....2010/9/16......4.........636.....2010/9/17......5.........787.....2010/9/20......1.........328.....2010/9/21......2.........229.....2010/9/23......4.........1110...2010/9/24......5.........5511...2010/9/27......1.........4612...2010/9/28......2.........3313...2010/9/29......3.........10我使用MAX函數求9/13-9/17.....=MAX(C2:C6)但是向下複製時9/20-9/2
Tags:
工作
All Comments
By Rebecca
at 2010-11-20T22:44
at 2010-11-20T22:44
By Eden
at 2010-11-22T08:11
at 2010-11-22T08:11
By Una
at 2010-11-21T07:21
at 2010-11-21T07:21
By Hedy
at 2010-11-22T08:42
at 2010-11-22T08:42
Related Posts
車禍可以要求哪些賠償
By Agnes
at 2010-11-19T00:00
at 2010-11-19T00:00
行政學選擇題考古題疑問!
By Margaret
at 2010-11-19T00:00
at 2010-11-19T00:00
這女生來回徘迴走來走去?
By Carol
at 2010-11-19T00:00
at 2010-11-19T00:00
全家儲備主管(詳細內容)~急
By Ursula
at 2010-11-19T00:00
at 2010-11-19T00:00
香港機+酒如何選擇較好?
By Charlie
at 2010-11-18T00:00
at 2010-11-18T00:00