Excel Forum
Similar Content
WEEKNUM UDF for Excel Versions That Don't Contain This Function - UDF
Macro: This is a WEEKNUM UDF for Excel. This allows you to determine the number of the week ...
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can...
Delete Duplicate Values in All Versions of Excel
Tutorial: How to delete duplicate values from a data set in all versions of Excel. This includes Ex...
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 595: DGET #NUM! Error same as Advanced Filter Duplicate Problem Extract Record


Learn about a problem that the DGET function and Advanced Filter have with criteria and duplicates. See how to switch to either the VLOOKUP function instead of DGET or Not Criteria for Advanced Filter. Extract Record Trouble





Got a Question? Ask it Here in the Forum.