UNIQUE & FILTER Functions Dashboard Part 3 of 6
Автор: Excel Campus - Jon
Загружено: 2020-01-23
Просмотров: 46117
Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint...
Learn to use the Dynamic Array Functions UNIQUE and FILTER. The UNIQUE function allows you to remove duplicates from a list using a formula. The FILTER function can help you pull multiple data entries out of a range based on a specified criteria.
This is Part 3 of 6 in a series that shows you how to build a dashboard for an attendance report.
This dashboard was originally submitted as an entry in the Excel Hash competition: • Excel Hash: Episode 2 - Learn How To Make ...
If you’d like to see the accompanying blog post on my website, you can find it at this link: https://www.excelcampus.com/functions...
Additional Resources:
Part 1 of 6: How to use the XOR Function: • How To Use The Xor Function In Excel
Part 2 of 6: How to use XLOOKUP for Reverse Order Search: • How to use XLOOKUP for Reverse Order Search
Excel Hash: Attendance Report with Storm Clouds & Fireworks: • Excel Hash: Episode 2 - Learn How To Make ...
Dynamic Array Functions & Formulas that Spill • Dynamic Array Functions Are The Best New E...
#MsExcel #ExcelCampus
00:00 Introduction
00:12 Dynamic Array Functions
01:04 The UNIQUE Function
02:00 The FILTER Function
04:27 Combining the Functions
05:12 Filtering for All Departments
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: