Advanced Filter with Formulas Unique Rows - Search Videos

Unique rows

To extract a list of unique rows from a set of data, you can use the UNIQUE function together with the SORT function. In the example shown, the formula in E5 is: =SORT(UNIQUE(B5:C15)) which return the 6 unique rows in the range B5:C15, sorted by group.

Filter Formula Tutorial

Excel Filter Function - Explained with Examples Video

Excel Filter Function - Explained with Examples Video

FILTER Function

FILTER Function

Shortcut to Filter by Cell's Value in Excel - Excel Campus

Shortcut to Filter by Cell's Value in Excel - Excel Campus

excelcampus.com

Top videos

Filter exclude blank values

Filter exclude blank values

FILTER with partial match

FILTER with partial match

Unique values ignore blanks

Unique values ignore blanks

Filter Formula Examples

Filter values in array formula

Filter values in array formula

Filter text contains

Filter text contains

Basic filter example

Basic filter example

Filter exclude blank values

Filter exclude blank values

FILTER with partial match

FILTER with partial match

Unique values ignore blanks

Unique values ignore blanks

Unique values with criteria

Unique values with criteria

Unique values with multiple criteria

Unique values with multiple criteria

Excel Advanced Filter - A Complete Guide with Examples

Excel Advanced Filter - A Complete Guide with Examples

UNIQUE function in Excel (How to 6 Examples)

UNIQUE function in Excel (How to 6 Examples)

exceloffthegrid.com

Excel: Combining Unique and Sort functions

chrismenardtraining.com

How to use Advanced Filter in Excel(Multiple Criteria)

5.2K viewsJul 22, 2020

YouTubeExcel World

Advance Filter in Excel | Ms Excel - Filtering Data

13.9K viewsJan 2, 2020

YouTubeInnozant

MS Excel - Filtering Data

2.1M viewsJan 15, 2018

YouTubeTutorialsPoint

Phrases v. Clauses

635.9K viewsMay 29, 2014

YouTubeEnglish Language 101

MS Excel - Advanced Filters

1.7M viewsJan 15, 2018

YouTubeTutorialsPoint

Create Custom Filters Using Excel Advanced Filter

189K viewsJun 6, 2012

YouTubeTrainSignal is now Pluralsight

Advanced or intelligent joins in sql server - Part 13

614.2K viewsAug 18, 2012

YouTubekudvenkat

Excel 2010: Simple Formulas

497.4K viewsNov 18, 2010

YouTubeLearnFree

How to use the SUMIFS function in Microsoft Excel

914.8K viewsDec 4, 2019

YouTubeMicrosoft 365

How to Create Dashboards in Excel

842.8K viewsJan 27, 2018

YouTubeHowtoExcel.net

Techniques To Become a Top Floral Designer

2.9M viewsApr 24, 2012

YouTubeLawrence Gerald

Excel Sorting and Filtering Data

1M viewsJun 7, 2018

YouTubeThe Organic Chemistry Tutor

How to use the UNIQUE formula in Google Sheets

29.3K viewsMay 9, 2018

How to use data validation in Microsoft Excel

74.8K viewsJan 24, 2013

How to use COUNTIF and COUNTIFS in Microsoft Excel

1M viewsJan 27, 2020

YouTubeKevin Stratvert

Using the Excel FILTER Function to Create Dynamic Filters

513.5K viewsApr 5, 2021

YouTubeTechnology for Teachers and Students

Excel Dynamic Arrays (How they will change EVERYTHING!)

779.3K viewsOct 18, 2018

YouTubeLeila Gharani

Advanced Filter Excel (And, Or, Between Conditions for Criteria R…

823.6K viewsMar 8, 2018

YouTubeLeila Gharani

Excel Cell References 15 Examples Formulas, Conditional Formatting …

601.9K viewsNov 6, 2009

YouTubeexcelisfun

Advanced Pivot Table Techniques (to achieve more in Excel)

2.3M viewsApr 8, 2021

YouTubeLeila Gharani

JSPs and Servlets Tutorial 01 - Setting up

1.3M viewsApr 29, 2011

YouTubeJava Brains

See more videos