New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.
Home
Microsoft Office How to Extract a unique list from a huge data set in MS Excel
![](https://assets.content.technologyadvice.com/thumbnail_Logos_Wonder_How_To_color_light_21e00e7b4a.webp)
By getexcellent
Apr 27, 2010 06:11 PM
![Excel spreadsheet showing sales data with an advanced filter dialog box open.](https://assets.content.technologyadvice.com/634757252786682508_204b3009e3.webp)
Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.
Comments
Be the first, drop a comment!