Extract Data Based on a Drop Down List Selection in Excel | Filter Data With Drop Down List Excel
8:13
YouTubeChester Tugwell
Extract Data Based on a Drop Down List Selection in Excel | Filter Data With Drop Down List Excel
In this video I demonstrate how to filter or extract data based on a drop-down list selection in Excel. This method is only available to Excel 365 users. The functions used in this video are: UNIQUE, SORT and FILTER. 👍👍If you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺 ...
343.3K viewsFeb 26, 2021
Chester Tugwell: Most Viewed Videos
AutoFill Dates in Excel - Days, Weekdays, Months & Years
2:54
AutoFill Dates in Excel - Days, Weekdays, Months & Years
YouTubeChester Tugwell
1.3M viewsJan 18, 2018
Automatically Update Data in Another Excel Worksheet or Workbook - 3 Methods
17:57
Automatically Update Data in Another Excel Worksheet or Workbook - 3 Methods
YouTubeChester Tugwell
794.2K viewsSep 5, 2022
How to Compare Two Excel Sheets and Find Differences
8:47
How to Compare Two Excel Sheets and Find Differences
YouTubeChester Tugwell
767.2K viewsJan 21, 2021
Top videos
How to Search and/or Replace Across All or Multiple Worksheets in Excel
2:56
How to Search and/or Replace Across All or Multiple Worksheets in Excel
YouTubeChester Tugwell
41.2K viewsSep 1, 2021
How to Perform an Excel IF GREATER Than & LESS Than Formula
6:32
How to Perform an Excel IF GREATER Than & LESS Than Formula
YouTubeChester Tugwell
334.9K viewsJun 10, 2020
Copy All Highlighted / Coloured Cells or Records to Another Excel Worksheet
7:11
Copy All Highlighted / Coloured Cells or Records to Another Excel Worksheet
YouTubeChester Tugwell
73.2K viewsJul 20, 2020
Latest From Chester Tugwell
How to Split a Cell into Separate Rows - Create Record for Each Item in Cell
2:33
How to Split a Cell into Separate Rows - Create Record for Each Item in Cell
YouTubeChester Tugwell
5.1K views3 months ago
IF Function in Excel with Multiple Conditions - 2, 3 or More Conditions
8:26
IF Function in Excel with Multiple Conditions - 2, 3 or More Conditions
YouTubeChester Tugwell
6K views7 months ago
How to Sum by Month in Excel | SUMIF by Month and Year
4:02
How to Sum by Month in Excel | SUMIF by Month and Year
YouTubeChester Tugwell
9K views7 months ago
How to Search and/or Replace Across All or Multiple Worksheets in Excel
2:56
How to Search and/or Replace Across All or Multiple Worksheet…
41.2K viewsSep 1, 2021
YouTubeChester Tugwell
How to Perform an Excel IF GREATER Than & LESS Than Formula
6:32
How to Perform an Excel IF GREATER Than & LESS Than For…
334.9K viewsJun 10, 2020
YouTubeChester Tugwell
Copy All Highlighted / Coloured Cells or Records to Another Excel Worksheet
7:11
Copy All Highlighted / Coloured Cells or Records to Another Excel …
73.2K viewsJul 20, 2020
YouTubeChester Tugwell
How to Get a List of all Files in a Folder and Subfolders into Excel
3:15
How to Get a List of all Files in a Folder and Subfolders into Excel
118.1K viewsJan 21, 2021
YouTubeChester Tugwell
How to Put Excel Formulas in a Word Document
5:10
How to Put Excel Formulas in a Word Document
71.5K viewsApr 27, 2021
YouTubeChester Tugwell
How to Combine Multiple Rows Into One Cell in Excel: With or Without Formula 📊
2:25
How to Combine Multiple Rows Into One Cell in Excel: With or Without …
115.5K viewsAug 29, 2023
YouTubeChester Tugwell
How to Create a Summary Table in Excel | Using Excel Formula or PivotTable
7:34
How to Create a Summary Table in Excel | Using Excel Formula or Piv…
73.8K viewsJun 12, 2023
YouTubeChester Tugwell
23:52
How to Create an Automated Invoice in Excel | Including Formulas and …
669.1K viewsFeb 23, 2022
YouTubeChester Tugwell
7:41
Excel: IF Cell Contains Text Then Copy to Another Sheet | Copy Cel…
378.8K viewsApr 12, 2021
YouTubeChester Tugwell
6:29
Combine Data from Multiple Sheets into One Sheet In Excel | Consolid…
288.7K viewsFeb 6, 2023
YouTubeChester Tugwell
3:36
How to Return a Blank Cell If Zero in Excel? 3 Methods- IF Formula, Cu…
234.8K viewsFeb 18, 2021
YouTubeChester Tugwell
6:38
Excel Lookup and Find the 2nd, 3rd, 4th or Nth Occurrence / Match (Wit…
60.7K viewsAug 18, 2021
YouTubeChester Tugwell
1:09
How Do I Divide a Whole Column, Row or Sheet in Excel by One Nu…
172.6K viewsOct 31, 2022
YouTubeChester Tugwell
5:37
How to Simultaneously Freeze Rows and Columns in Excel
319.5K viewsFeb 23, 2018
YouTubeChester Tugwell
8:15
How to Transfer Data From One Worksheet to Another Automatical…
52.5K viewsMay 12, 2021
YouTubeChester Tugwell
8:22
How to Use XLOOKUP Across Two Worksheets | XLOOKUP Example…
126K viewsDec 9, 2022
YouTubeChester Tugwell
11:48
VLOOKUP | Sum ALL Matching Values Or Sum ENTIRE MATCHIN…
254.8K viewsSep 11, 2020
YouTubeChester Tugwell
4:10
Excel IF Range Contains Value | How to Perform an IF Statement o…
106.3K viewsJul 1, 2021
YouTubeChester Tugwell
9:57
How to Join Tables in Excel | Merge or Append Data From Different Sh…
154.6K viewsAug 26, 2022
YouTubeChester Tugwell
2:23
Hyperlink to a Specific Cell In Excel
145.4K viewsJan 16, 2021
YouTubeChester Tugwell
6:43
Excel - One Slicer for Multiple PivotTables with Different Data So…
188.5K viewsJan 10, 2022
YouTubeChester Tugwell
17:25
VBA to Automate Sending Email From Excel Table with Attachmen…
157K viewsFeb 11, 2022
YouTubeChester Tugwell
5:13
How to Create a Macro Button in Excel | Assign a Macro to a Butto…
85.9K viewsMar 30, 2021
YouTubeChester Tugwell
5:53
How to Count Duplicates in Microsoft Excel | Group and Coun…
34.7K viewsOct 5, 2022
YouTubeChester Tugwell
4:51
Merge Duplicate Rows in Excel Combining Unique Values in One …
160.2K viewsMay 18, 2023
YouTubeChester Tugwell
6:20
How Can I Add a Vertical Line to an Excel Graph?
90.7K viewsFeb 22, 2021
YouTubeChester Tugwell
10:00
Excel VBA - Clear Invoice and Automate Next Invoice Number
133.8K viewsFeb 28, 2022
YouTubeChester Tugwell
1:52
Insert a Blank Row Between Each Data Row or Record in Excel
153.4K viewsFeb 11, 2020
YouTubeChester Tugwell
17:57
Automatically Update Data in Another Excel Worksheet or Work…
794.2K viewsSep 5, 2022
YouTubeChester Tugwell
See more videos
Static thumbnail place holder