excel高级筛选
Here's the final video update for this week -- Automatically Copy Excel Data to Another Sheet. This video now shows the steps in Excel 2010 or Excel 2007, instead of Excel 2003.
这是本周的最后视频更新-自动将Excel数据复制到另一个工作表。 现在,此视频显示了Excel 2010或Excel 2007(而不是Excel 2003)中的步骤。
To wrap up this week of updates, here are links to a few of my previous Excel Advanced Filter articles and posts. You probably know all the basics, but maybe you've missed a few of these tips and tricks.
为了总结本周的更新,以下是一些我以前的Excel Advanced Filter文章和帖子的链接。 您可能知道所有的基本知识,但也许您错过了一些提示和技巧。
Click a Map To Filter Excel Data - set up an Excel workbook so you can click on a map of the USA, and see a list of fictional doctors in the state that you selected.
单击地图以筛选Excel数据 -设置一个Excel工作簿,以便您可以单击美国的地图,并在您选择的状态下查看虚构医生的列表。
Excel Advanced Filter Complex Criteria – see examples of criteria you can use when setting up an advanced filter
Excel高级筛选器复杂条件 –请参阅设置高级筛选器时可以使用的条件示例
Create New Sheets from Filtered List – a macro uses an Advanced Filter to create a separate sheet of orders for each sales rep visible in a filtered list
从过滤列表创建新表 –宏使用“高级过滤器”为过滤列表中可见的每个销售代表创建单独的订单表
Note: Remember -- the 30 Excel Functions in 30 Days challenge starts January 2nd. See you then!
注意 :请记住-30天30个Excel函数挑战将于1月2 日开始。 回头见!
观看Excel 2010高级筛选器视频 (Watch the Excel 2010 Advance Filter Video)
See how to automatically copy data to a different worksheet, with an Advanced Filter, in Excel 2010 or Excel 2007.
了解如何在Excel 2010或Excel 2007中使用高级筛选器将数据自动复制到其他工作表。
翻译自: https://contexturesblog.com/archives/2010/12/31/excel-advanced-filter-update/
excel高级筛选