13
【笔记】Excl分类汇总
source link: https://feiju12138.github.io/2022/09/19/Excl%E5%88%86%E7%B1%BB%E6%B1%87%E6%80%BB/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
【笔记】Excl分类汇总
2022-09-19
2
Excl分类汇总学习笔记
- 分类汇总之前，要先将数据进行分类排序
- 选择需要分类汇总的数据->
数据->分类汇总->指定分类字段、汇总方式、汇总项->确定
- 展示结果可以通过左上角筛选
1：只展示所有汇总结果2：展示分类汇总结果、所有汇总结果3：展示所有数据、分类汇总结果、所有汇总结果
- 如果需要展示多个汇总结果，左上角依然可以筛选展示结果
</div
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK