Excel Forum
Similar Content
Require a Unique List of Numbers in a Range in Excel
Tutorial: I'll show you how to require a user to enter a unique number into a range of cells in Exce...
Filter While Leaving Original Data Intact in Excel
Tutorial: How to filter in Excel by copying the filtered data to a new location without doing anyth...
Display the AutoFilter Criteria Applied to a Data Set in a Cell in Excel - UDF
Macro: This free Excel UDF (user defined function) allows you display the filter criteria tha...

Excel Magic Trick 581: Unique List With Criteria Using Advanced Filter

See how to use Advanced Filter with criteria to extract a unique list of employees for each department from a huge data set with transactional records.

Got a Question? Ask it Here in the Forum.