All articles in 'Huis' Category

Hui’s Calendar Tool (as Borrowed from Chandoo)

Published on Apr 7, 2014 in Automation, Huis, Posts by Hui, VBA Macros
Hui’s Calendar Tool (as Borrowed from Chandoo)

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 »

Countif – Quick Tip

Published on Dec 16, 2013 in Huis, Posts by Hui, Quick Tip
Countif – Quick Tip

Learn how to Count Text, Blanks and Non-Blank cells with this Countif() Quick Tip

Continue »

Chandoo.org produces it’s Second MVP.

Published on Oct 10, 2013 in Huis, Posts by Hui
Chandoo.org produces it’s Second MVP.

Chandoo.org produces it’s Second Excel MVP.

Continue »

How to Solve an Equation in Excel

Published on Sep 19, 2013 in Huis, Posts by Hui
How to Solve an Equation in Excel

How to Solve an Equation in Excel

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
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 »

We Want You – Revisited

Published on Jun 17, 2013 in Huis, Posts by Hui
We Want You – Revisited

Chandoo.org wants your ideas.
Here’s your chance to let us know what you would like to see posted about, at Chandoo.org

Continue »

Formula Forensics No. 033 – Interpolation

Published on Feb 8, 2013 in Formula Forensics, Huis, Posts by Hui
Formula Forensics No. 033 – Interpolation

Today, Formula Forensics examines 3 techniques to determine an interpolated value along a curve.

Continue »

Check Cells for Equality – Follow Up [Quick Tip]

Published on Oct 16, 2012 in Huis, Posts by Hui, Quick Tip
Check Cells for Equality – Follow Up [Quick Tip]

Excel contains an often overlooked function
The Excel = Function
Today we quickly review what it can do for us.

Continue »

Formula Forensics No. 029 SumIf with Inconsistent Column Layouts

Published on Sep 20, 2012 in Formula Forensics, Huis, Posts by Hui
Formula Forensics No. 029 SumIf with Inconsistent Column Layouts

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

Continue »

Formula Forensics No. 028 – It’s Just a Jump to the Left

Published on Sep 6, 2012 in Formula Forensics, Huis, Posts by Hui, Random
Formula Forensics No. 028 – It’s Just a Jump to the Left

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.

Continue »

Formula Forensics No. 027 – Remove Leading Zeroes

Published on Aug 23, 2012 in Formula Forensics, Huis, Posts by Hui
Formula Forensics No. 027 – Remove Leading Zeroes

Today in Formula Forensics we look at how to strip away leading zeroes from strings with this simple array formula

Continue »

Formula Forensics No. 026 – Highlight Only Duplicate Entries

Published on Aug 9, 2012 in Formula Forensics, Huis, Posts by Hui
Formula Forensics No. 026 – Highlight Only Duplicate Entries

Today Formula Forensics looks at a formula that Highlights Only the Duplicate Entries in a range.

Continue »

Formula Forensics 025. Count Unique Values in a Range

Published on Jul 26, 2012 in Formula Forensics, Huis, Posts by Hui, wonder why
Formula Forensics 025. Count Unique Values in a Range

Need to count how many unique values occur in a range?
Learn how to do this and how the formula works right here.

Continue »

Formula Forensics 024. Is this number a Prime Number ?

Published on Jul 12, 2012 in Formula Forensics, Huis, Posts by Hui
Formula Forensics 024. Is this number a Prime Number ?

Is my number a Prime Number?
What is a Prime Number?

Today in Formula Forensics we answer both questions.

Continue »

How to make a Spoke Chart

How to make a Spoke Chart

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 »