UNIQUE & FILTER Functions Dashboard Part 3 of 6

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.

Additional Resources:

#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

[wayneedmondson]

Hi Jon.. great video. UNIQUE and FILTER are like magic.. no more wacky array formulas with CSE. Although they were fun to master, you can't beat the new functions for getting real work done. Thanks for sharing your knowledge and techniques.. much appreciated. Thumbs up for Excel Campus!

[TravelRunner]

This video had me at "Dunder Mifflin Attendance Report". I wonder if Dwight gave Jim any Demerits or if Jim gave Dwight any Full Disadulations. Anyway, thanks for the great video, Jon!

[sasavienne]

Thanks Jon. Great work...
The Unique and the filter formulas are the best in Excel.

[darrylmorgan]

Hi Jon!Awesome Tutorial Loved the Tip on How to Reference a Merged Cell Thank You :):):)

[mikelennon]

Does anyone knows how to create a macro that Searches entire Workbook and returns all Records which match a certain value from a drop down list? One to many or many to many relationship!
e.g. if we have a list of many large organization in a worksheet and have a list of all of their employee, first name, last name, phone, email, ( many per organization) in another worksheet.
How one can see the records of all employees in an organization by selecting the organization's name from a list or drop down box, etc. I would appreciate if your insights.

[UtuDudas]

Lets that the array contains both text and values in different columns, is there a way to do a product for each value in the value columns with a number outside the array?

[garyknight]

Hello Jon:
I got so excited about this Excel Campus Tutorial... so excited, only to find out that UNIQUE & FILTER are not available to me using my Office 365 Pro subscription as of January 2020. That being said it was a great carrot to dangle in front of all of us. Do you have any estimate for release data of Unique & Filter, I guess the same goes for Xlookup? Indeed a great presentation.

[quantum]

Hello I am using excel 2019 student version. It came bundled with my laptop. Is there a way I can access these dynamic functions ?

[sinimematthiasemmanuel-pau]

Great work, Please how do i download these dynamic array functions (Unique, Filter...) finding it difficult to have them added into excel .
Thank you

[winningabe]

Hey, it's a great tutorial but don't you think it is easier to user VLOOKUP formula?

[ennykraft]

I got so excited when you started this video, hoping Microsoft had finally released dynamic arrays after dangling that carrot in front of our noses but still no joy. It’s becoming really annoying and I wonder why the heck to I pay for 365 if no interesting updates get released? So that I can create animated gifs in PowerPoint???
You should have mentioned that right now only 365 Insiders can use the functions you use. I know I could become one but I teach Excel and my Office has to be both stable and exactly like the ones my students use.

[AnilKumar-kext]

Wow, awesome!!
Is there any way to count unique values from a set of data (with UNIQUE function), while applying one or more logical criteria from other columns?

[sukkurimran]

Unique function is not included in my excel 2019, Kindly guide me how to add this function.