Formula Writing

The Anchored COUNTIF is one of my favorite Excel formula tricks.   Using this technique provides a number of unique benefits, which make the formula worthwhile to learn.  While not as common as some of the more popular lookup formulas out there, being able to write an Anchored COUNTIF is still a great tool that can ... Continue Reading >>
If you're brand new to VLOOKUP or haven't used the formula in a while, the following quick reference guide is a great resource to have handy.  It's created by the folks at Microsoft, so you know it's legitimate. Reference Guide Summary The quick reference guide is in PDF format and is three pages long.  It goes into ... Continue Reading >>
The vast majority of Excel users have never used VLOOKUP's range lookup feature.  Most Excel users familiar with the VLOOKUP formula are just conditioned to know that, when they get to the range lookup option portion of the VLOOKUP syntax, they should just put in the word "FALSE" because they want an exact match.  This ... Continue Reading >>
Writing a Nested IF Statement is widely considered a rite of passage for beginning Excel users who are looking to become more advanced.  The first time I used this technique was during my new employee training, right before I became a business analyst in management consulting.  The overall concept of writing a Nested IF is ... Continue Reading >>
Excel's MATCH formula is an extremely useful yet underutilized function within Excel's toolkit of formulas.  The reason people underestimate its value is because the MATCH formula's primary objective is fuzzy and ambiguous.  Without the proper context, its usefulness and potential applications are not obvious. The MATCH Continue Reading >>
One of the most annoying things to have to do in Excel is writing a Nested IF statement.  For those of you that haven't done this before, a Nested IF is basically a long formula with multiple IF conditions that you need to account for.  The most common usage of this formula is to assign ... Continue Reading >>
I generally give Excel a lot of credit for being an intuitive and easy to learn tool.  However, writing criteria statements that link to cells is probably one of the most un-intuitive aspects of formula writing in Excel.  This is a very common mistake that occurs and therefore, should always be error-checked whenever you are ... Continue Reading >>

Related pages

recreation.ucla.eduisna vlookuplogical tests in excelexcel match commandvlookup on multiple criteriaexcel compare two columns and find matchesexcel spreadsheet tips and tricksexcel offset vbahlookup excel 2013vlookup vba codehow do i create a column chart in exceltick in wingdingshow to perform vlookup in excel 2007excel function stdevexcel formula if cell containsucla anderson deanvlookup table rangemicrosoft excel 2010 functions & formulas quick reference guidevlookup exceexcel making graphsexcel generatorstick mark in powerpointexcel functions tutorial with examplesexcel tax calculatornest functions in excelmyucla comexcel randomiserexample of countifcomplex excel formulas with exampleshow to use if condition in excel 2007excel formula arrayexcel isna formulahow to compare two columns of data in excelexcel formula not working when draggingcombine formula in excelhistograms excelvlookup in excel formula examplerandomizing in excelexcel searchable databasesample spreadsheetsexcel nested if formulacheck symbol ms wordvlookup worksheetexcel column chart with linehow to use vlookup in excel to compare two columnshow to use vlookup in excel 2003 step by stepexcel dragging formulashow to conditional format in excel 2010insert tick symboldelete duplicate data excelfilter excel shortcutworking at zs associatestop 10 popular websitesmicrosoft excel iferrordeleting duplicates excelhighlight shortcut excelsumproduct vlookupvlookup example excelexcel vba open excel filemost common functions in excelcumulative bar graphexcel random integercount duplicate values excelexcel count cellsconditional formatting text in excelpasting in excelonline histogram creatorhow to insert a tick on wordformulas on excel spreadsheetms excel vlookup and hlookuphow to make stacked bar graph in exceltick symbol in excel 2007excel query tablesw-4 worksheet calculatorexcel lookup function examplesduplicate records in excelblank excel formulavlookup formularandomizing a list in excel