Search

# All articles with 'iferror' Tag

## Speed up your Excel Formulas [10 Practical Tips]

Published on Apr 14, 2023 in Excel Howtos, Learn Excel

Excel formulas acting slow? Today lets talk about optimizing & speeding up Excel formulas. Use these tips & ideas to super-charge your sluggish workbook. Use the best practices & formula guidelines described in this post to optimize your complex worksheet models & make them faster.

1. Use tables to hold the data
2. Use named ranges & named formulas
3. Use Dynamic Array formulas
5. Use manual calculation mode

… and more. Read on to learn these top 10 tips & ideas to improve performance of your excel formulas.

Continue »

## #### in Excel cell

Published on Dec 10, 2022 in Learn Excel

You open an Excel file and some cells show #### instead of the value. Here is a quick fix.

Continue »

## Top 10 Excel formulas for IT people

Published on Jun 18, 2020 in Learn Excel, Project Management

Are you in IT & use Excel often? This article explains top 10 formulas for IT professionals. Useful for project managers, IT analysts, Testing people and BAs.

We cover a 10 practical situations and explore various Excel formulas to solve them. Example workbook provides more details too.

Continue »

## Top 10 Excel Formulas for any situation

Published on Mar 27, 2019 in Learn Excel

Excel has hundreds of formulas. But as a new learner or user, you may want to just focus on top 10 formulas to get the most out of it. Assuming you already know the basics (check out Beginner Excel page if you are complete newbie), here is a list of top 10 Excel formulas for you.

Continue »

## Visualizing Commonwealth games performance – Interactive chart

Published on Apr 13, 2018 in Charts and Graphs, Power Query

The 2018 edition of Commonwealth games are on for a week now. Both of my homes – India and New Zealand have been doing so well. Naturally, I wanted to gather games data and make something fun and creative from it. Here is my attempt to amuse you on this Friday.

Looks interesting? Want to know how to make something like this on your own? Then read on…

Continue »

## Generating sequence numbers from cluster values [VLOOKUP to the rescue]

Published on Jun 2, 2016 in Excel Howtos

Last night I got an email from Joshua, one of our readers with the subject – Hard Excel problem. Hard?!?, at this stage of summer, the hard problems seem to be (in no particular order),

1. Lack of good quality mangoes to eat
2. Intense heat and humidity
3. Lack of good quality mangoes to eat

Yes, I like mangoes.

Any how, back to Joshua’s email, So I got curios and read it. He is facing a curious problem.

Continue »

## How many ‘Friday the 13th’s are in this year? [Formula fun + challenge]

Published on May 13, 2016 in Excel Howtos, Learn Excel

Today is Friday the 13th. If you are a raging friggatriskaidekaphobiac, I suggest you to stop reading this post. For the rest of you, I have something fun.

Given a year in cell C3, let’s find out all the months with Friday the 13th. Something like above.

Continue »

Published on Nov 4, 2015 in Charts and Graphs, Learn Excel

Imagine you are the head of training department at ACME Inc. You arrange training programs round the year to empower your team. It is hard work, coordinating between employees, trainers, department heads, venues and coffee machines. What if there is something to help you keep track of all this? I am not talking about getting you a shiny new iPad, you silly. I am talking about a tracker & calendar built in Excel that ties everything together (well, almost everything, you still have to fill the coffee machine.)

We are going to build a training program tracker & calendar using Excel.

Continue »

## CP037: Error error on the wall, How do I fix you all? – Understanding & Fixing Excel Errors

Published on Jun 25, 2015 in Chandoo.org Podcast Sessions

In the 37th session of Chandoo.org podcast, Let’s debug ’em #VALUEs & #N/As.

What is in this session?

In this podcast,

• Introduction to Excel formula errors
• The easy kind: syntax errors
• The triky ones: # ERRORs
• Fixing errors – using IFERROR & ISERROR
• Error checking & debug options
• Using Errors deliberately – charts & data validation
• A challenge for you – produce #NULL error
• Conclusions
Continue »

## Calculating Billy’s total working hours [solution & discussion]

Published on Jun 22, 2015 in Excel Challenges

Few days ago, I asked you “How many hours did Billy work?” There were more than 100 responses with lots of innovative solutions.

So today, let’s examine various ways to calculate total working hours given start & end times of tasks. Please watch below video.

Calculating Bill’s total working hours (video)

Continue »

## Excel to the Next Level by Mastering Multiple Occurrences

Published on Dec 9, 2014 in Learn Excel

This is a guest post by Sohail Anwar.

August 29, 1994. A day that changed my life forever. Football World Cup? Russia and China de-targeting nuclear weapons against each other? Anniversary of the Woodstock festival?

No, much bigger: Two Undertakers show up at WWE Summerslam for an epic battle. Needless to say: MIND() = BLOWN().

And thus begun one boy’s journey into understanding the phenomenon of Multiple Occurrences.

My journey continued, when just a few years later my grandfather handed me down a precious family heirloom: A few columns of meaningless data that I could take away and analyze in Excel. You may laugh but in the 90’s, every boy only wanted two things 1) Lists of pointless data and …

Continue »

## Looking up when data won’t play nice – few more alternatives

Published on Nov 12, 2014 in Learn Excel, VBA Macros

Recently, we discussed about the case of unwieldy data and how we lookup what we want using formulas like SUMIFS. Today, let us learn few more ways to solve the same problem.

Suitable structure spawns simple solutions

Poorly structured is the 2nd biggest problem of analysts. The first one is not enough coffee. That is why there is a dictum in the data analytics world.

Structure is everything

So, we can easily solve our lookup problem, if our data were to magically re-arranged in 2 column fashion – Data & Value.

Continue »

Published on Mar 19, 2014 in excel apps, Learn Excel

Anyone running a small business knows the oozing bits of joy when you hear a customer saying, “Can you send me an invoice?”

While creating an invoice is an easy task, if you want something that is professional looking, easy to manage and works well, then you are stuck.

That is where Excel really shines. By using an invoice template, you can quickly create and send invoices.

Today I want to share one such template with you all. Why? Because we are awesome like that.

Continue »

## CP002: VTALKUP – 5 Excel lookup functions demystified + 4 Resources for you

Published on Mar 13, 2014 in Chandoo.org Podcast Sessions

In the second session of Chandoo.org Podcast, We will be learning how to use 5 Excel lookup functions.

What is in this session?
In this session, we tackle one of the most important areas of Excel. The lookup functions.

You will learn,

• Why lookup functions are necessary
• 5 Important lookup functions in Excel – VLOOKUP, HLOOKUP, LOOKUP, MATCH & INDEX
• When & how to use each of these 5 functions?
• Extreme scenarios:
• What happens when the value you are looking up is not there?
• What if too many items match the lookup value?
• What if you have too many conditions in the lookup criteria?
• Using IFERROR function
• Re-cap of the new powers you acquired
• 4 Resources for you to learn lookup functions better
Continue »

## Formula Forensics No. 34. Extract words from a cell, where they occur in a list of words.

Published on Sep 12, 2013 in Formula Forensics, Huis, Posts by Hui

Use Excel to extract matching words from a list of words from a cell containing a sentence into individual cells in the order they exist

Continue »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.