My Spreadsheet Lab
  • Home
  • Templates
  • Excel Tips
  • Video Tutorials
  • Excel Blog
  • Excel Coach
  • Excel Training
  • Contact Kevin

Errors

You are here: HomeArticlesArchive by Category "Errors"

Errors

False Friends in Excel

  • January 04th ,2019
  • Kevin Lehrbass
  • Efficiency, Errors
  • chess, counter, expanding range, match
  • 0
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

The term False Friends is used in various fields including linguistics and chess. In this post I’ll explain how it applies to Microsoft Excel! (more…)

Excel Error “You can’t enter an array formula over merged cells”

  • May 14th ,2018
  • Kevin Lehrbass
  • Errors
  • Array Formulas
  • 0
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

You created a cool array formula and then merged it across several cells. Later, you realize that you need to modify this array formula. When you try to press Control Shift Enter you get this horrible error: (more…)

I SEE “XLFN” !?!? WHAT IS HAPPENING?

  • June 26th ,2017
  • Kevin Lehrbass
  • Errors
  • 4
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

Despite how amazing Excel is there are times when you’ll find yourself shaking with fear! For example, have you ever seen anything as scary as this  =ISERROR(FIND(_xlfn.CONCAT($A2:$E2),_xlfn.CONCAT($I$2:$M$6))) What is xlfn ??? (more…)

What is the easiest way to calculate grades in Excel?

  • June 19th ,2017
  • Kevin Lehrbass
  • Efficiency, Errors
  • Binning, grades, if
  • 9
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

Although the VLOOKUP versus INDEX/MATCH debate gets most of the attention there are MANY more topics to debate in Excel. When calculating student grades what method is best: NESTED IF  or  LOOKUP/BINNING TABLE? (more…)

The Dangers of Binning in Excel

  • December 12th ,2015
  • Kevin Lehrbass
  • Errors
  • Binning, index, match
  • 2
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

In Excel we can bin numbers. We can also bin letters. Rare but possible. However, be careful when binning a mix of letters and symbols! What could go wrong? A student who earns a B- could end up with an A- grade! (more…)

True Vlookup Tragedy

  • October 21st ,2015
  • Kevin Lehrbass
  • Errors, Tips
  • vlookup
  • 3
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

The vlookup function is often used to prove a bare minimum of Excel knowledge because it’s both useful and common. (more…)

Share

Newsletter

Do You Excel?

Kevin_Col-275x300-small-2019.png
“Improving your Excel skills can change your career!. Visit my 'EXCEL TRAINING' section!”

- Kevin Lehrbass

Excel Made Easy

Learn Excel

Free Templates

Video How-To's

© 2014 My Spreadsheet Lab| Entries (RSS)
website design & development by Engine Communications