Error Checking

Auditing an Excel file with a ton of tabs is one of the least enjoyable experiences in Excel.  When I worked in consulting, it wasn't uncommon for me to receive a file from a client containing 50 more spreadsheet tabs.  And as an analyst, I had the unfortunate task of having to review all of ... Continue Reading >>
The IFERROR formula was designed to solve a common aesthetic problem that most of us have encountered when using Excel - when we know that there are errors in our data, but we'd prefer not to see Excel's standard error message notation.  Error messages usually consist of all caps lettering that is preceded with the "#" ... Continue Reading >>
Photo by adamr Taking over another person's Excel file always has the potential to become a difficult task.  While some people actually create documentation, consider a new user's point of view, and take the time to call out the mousetraps that you might encounter, most of the time, you'll be getting a straight file dump.  Therefore, Continue Reading >>
Checking for errors in your Excel files is always a pain.  It's generally a very manual process that takes a lot of time, with a certain level of ambiguity regarding your return on investment - you could spend hours checking for issues in your Excel file, find nothing wrong, and your only tangible benefit is ... Continue Reading >>
INDEX MATCH Not Working?  The following article provides the most likely causes of your problems with using INDEX MATCH. If you're an advanced user of Excel, you've likely already made the switch from VLOOKUP to INDEX MATCH because of the several advantages that INDEX MATCH provides.  Within Excel, INDEX MATCH is one of the most Continue Reading >>
Five Ways to Find and Remove Duplicate Values in Excel For people who work with large data sets in Excel, or databases for that matter, one of the most common error checking tasks is the removal of duplicates values.  Some people refer to this process as de-duping.  The main reason this is necessary in data sets ... Continue Reading >>

Related pages

excel string comparisonhighlight duplicate rows in excelwhat is a vlookup functiontick symbol to copy and pastehow to use the lookup function in excel 2010dynamic array excelpurge excel fileexcel countif formulasremove excel duplicatesexcel generate unique random numbers3 axis graph excel 2010histogram bincompare columns in excel for matchesexcel check duplicate formulavlookup excel example 2010countif cell referencecheckbox in wingdingsexcel max formulastandard deviation bell curve excelexcel formulas columnrevenue projection template excelhistogram binsisna meaningisna vlookup excel 2010excel sorting formulavlookups in excel 2010countif in rangeexcel macro sheetlogon.ucla.eduexcel if statement with vlookupformula of vlookup and hlookupvba compare cell value to stringcheck duplicates excelduplicate rows in excelvlookup problemmba colexcel remove duplicate valuesvlookup in two columnsexcel compare lists for differencesadobe convert pdf to excelexcel formula highest valuematrix calculation in excelexcel formula vlookup examplems excel compare two columnshistagram makervlookup in excel for dummiesprimo pdf reviewhistogram creator onlineshortcut for filter in excel 2007vlookup with and functionexcel tutorial pivot tableshlookup excel examplewingding check markexcel formula filterexcel if formula multiple conditions examplesexcel comparison formuladocument tracker excel templateexcel macro format cellhow do i sort multiple columns in excelexcel formulas with examples in excel sheethow to create bar graph in excel 2010arrays excelvba find duplicatesvba if statement multiple conditionsvlookup example in excelgoals template excelgoldratt goalcountif vlookuplookup table excelmicrosoft excel format cells