Extract Unique lists in Excel - Including IF conditions
This video is going to demonstrate how to extract the unique values or lists from a table or dataset in Excel by using a formula. It is going to be a dynamic Unique function. There will also be a more advanced formula that shows you how to extract a unique list that has an additional 'if' or 'where' condition.
Write in the comments if there is another formula that is causing you problems that you need help solving.
Try out some other Filter Functions here:
Filter Multiple Pages
• Excel FILTER FUNCTION across multiple...
Filter(Does Not Contain)
• FILTER FORMULA - does NOT contain - E...
Filter(Columns) instead of rows
• EXCEL Filter Rows & Columns
Filter Basics
• NEW - EXCEL FILTER Function - Everyth...
#uniqueformula
#uniquefunction
#excelformula
#filterfunction