If you need to create a chart in Excel based on changing criteria, it is easy to do with a dynamic chart using the FILTER function. You can even add the SORT function to get your chart sorted from highest to lowest or lowest to highest. We also show the UNIQUE function to create a data validation list that automatically updates.
Chapters:
0:00 Intro
0:32 Create a Table (CTRL+T)
1:39 Data to chart
2:10 FILTER function
4:15 Format numbers
4:30 Create chart
5:30 SORT function ascending
6:58 SORT function descending
7:45 Data Validation list by typing
9:20 UNIQUE function
9:45 SORT and UNIQUE function
10:08 Data validation list from dynamic range
Version for Dynamic array functions:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
#exceltraining #msexcel #chrismenardtraining #chrismenard
And make sure you subscribe to my channel!
EQUIPMENT USED
○ My camera – https://amzn.to/3vdgF5E
○ Microphone https://amzn.to/3gphDXh
○ Camera tripod – https://amzn.to/3veN6Rg
○ Studio lights https://amzn.to/3vaxyy5
○ Dual monitor mount stand https://amzn.to/3vbZSjJ
○ Web camera – https://amzn.to/2Tg75Sn
○ Shock mount https://amzn.to/3g96FGj
○ Boom Arm https://amzn.to/3g8cNi6
SOFTWARE USED
○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia
○ Screenshots – Snagit – https://chrismenardtraining.com/snagit
○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!