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...
Generate a Unique List of Random Numbers With a Simple Formula + (GUID/UUID Generator)
Tutorial: Sections: GUID/UUID V4 Formula in Excel Versatile Formula to Generate a Unique List of N...
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...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.