All articles in 'Huis' Category

Today we take a look at an exercise in how to develop a simple Calendar selection tool for your worksheets without using complex VBA Calendar Controls.
Continue »Chandoo.org produces it’s Second MVP.

Chandoo.org produces it’s Second Excel MVP.
Continue »Formula Forensics No. 34. Extract words from a cell, where they occur in a list of words.

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 »
Chandoo.org wants your ideas.
Here’s your chance to let us know what you would like to see posted about, at Chandoo.org

Today, Formula Forensics examines 3 techniques to determine an interpolated value along a curve.
Continue »![Check Cells for Equality – Follow Up [Quick Tip]](https://chandoo.org/wp/wp-content/uploads/2012/10/Equal.png)
Excel contains an often overlooked function
The Excel = Function
Today we quickly review what it can do for us.

How do we perform a Sumif on seemingly randomly spaced columns?
Today in Formula Forensics we look at a solution to do just that.

VLookup is often seen as the poor cousin in the lookup function family and often gets overlooked when it comes to looking up values due to a common misconception that Vlookup doesn’t or can’t lookup values to the left of the reference value.
Today at Formula Forensics we will explode this myth and see how to make VLookup, lookup to the Left and we’ll explain how it works.

Today in Formula Forensics we look at how to strip away leading zeroes from strings with this simple array formula
Continue »
Today Formula Forensics looks at a formula that Highlights Only the Duplicate Entries in a range.
Continue »
Need to count how many unique values occur in a range?
Learn how to do this and how the formula works right here.

Is my number a Prime Number?
What is a Prime Number?
Today in Formula Forensics we answer both questions.
Continue »
Have you ever wanted to make your own Custom Chart type ?
MarnieB was asked by her boss to make a Spoke Chart !
This post will explain how you can make a custom Excel Spoke Chart and introduce you to techniques that can be used to make other custom chart types.
Continue »