作者:乔山办公网日期:
返回目录:excel表格制作
$a =
Array ( '1969-12-31' =>10, '1969-12-30' => 20,'1969-12-29' => 5,
'1969-12-28' => 6, '1969-12-27' => 30, '1969-12-26' => 70,
'1969-12-25'=> 33);
//转换成百这样的度二维内数组:容Array ( [0] => Array ( [day] => 1969-12-31 [sum] => 10 ) [1] => Array ( [day] => 1969-12-30 [sum] => 20 ) [2] => Array ( [day] => 1969-12-29 [sum] => 5 ) [3]... )
$b = Array();
foreach ($a as $key => $value) {
$b[]=Array('day'=>$key,'sum'=>$value);
}
在E1单元格输入以下公式,然后向下填充公式
=OFFSET(A$1,MOD(ROW(A3),3),INT((ROW(A1)-1)/3))
详见附图
比如要查百找“@”,可以用公式: =ADDRESS(MIN(IF(A1:E10="@度",ROW(1:10))),MIN(IF(A1:E10="@",COLUMN(A:E)))) 数组公式,按CTRL+SHIFT+回车键内结束公式。即可容显示:$B$6
怎么转换?二位的就是二维。