• About Me




    Lily@Melbourne, Australia

    Login

  • Follow 静水深流 || Still waters run deep on WordPress.com
  • Archives

Excel公式

如何将多行多列合并为一列
举个形象化的例子,在练习队列时,一班级的人可能先分成四小队,然后再合并成1整列
=INDEX(mydata,1+INT((ROW(D2)-1)/COLUMNS(mydata)),MOD(ROW(D2)-1+COLUMNS(mydata),COLUMNS(mydata))+1)
mydata:即需要转换的区域,先得选定命名。
D2: mydata起始位

如何显示1,1,2,2,3,3,……99,99,100,100……这一组序列
=INT((ROW()-ROW($A$1))/2)+1

如何复制公式
选中带有公式的单元格
点击命名栏,输入区域如A2:A2000
按回车键后在键盘上输入Ctrl + D( 往下填充的快捷键),即可。

比较两列是否相同
=IF(A2=B2,”Match”,”Not Match”)

Advertisements

发表评论

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / 更改 )

Twitter picture

You are commenting using your Twitter account. Log Out / 更改 )

Facebook photo

You are commenting using your Facebook account. Log Out / 更改 )

Google+ photo

You are commenting using your Google+ account. Log Out / 更改 )

Connecting to %s

%d 博主赞过: