Skip to content

Instantly share code, notes, and snippets.

@felixmon

felixmon/excel_functions_guides.md

Last active June 18, 2020 03:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save felixmon/f9567ff7a6e4be8e9a46528ea8df7d66 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save felixmon/f9567ff7a6e4be8e9a46528ea8df7d66 to your computer and use it in GitHub Desktop.
Download ZIP
Excel functions guides
Raw
excel_functions_guides.md

TRANPOSE

使得一行的数值根据另外一列的数值的改变而改变，关键点是函数输入结尾是以数组形式（CTRL+SHIFT+ENTER），而不是直接ENTER

https://support.microsoft.com/zh-cn/office/transpose-%e5%87%bd%e6%95%b0-ed039415-ed8a-4a81-93e9-4b6dfac76027?ui=zh-cn

多级下拉菜单

一级菜单决定下一级菜单的内容，举例：一级菜单选择江苏省，那么二级菜单只能出现南京市、苏州市，而不会出现西安市。功能实现的核心：

  1. 定义名称
  2. 下拉菜单（数据验证-序列）的值采用INDIRECT形式（来引用上述定义名称）

https://zhuanlan.zhihu.com/p/74687468

@felixmon

felixmon commented Jun 18, 2020

Copy link
Copy Markdown
Author

多级下拉菜单

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment