# All articles in 'Huis' Category

## What functions is Excel missing ?

Published on Jun 9, 2015 in Huis, Posts by Hui, Quizzes

What functions you believe Excel is missing?

Continue »

## Conditionally Format Chart Backgrounds

Published on Mar 27, 2015 in Charts and Graphs, Excel Howtos, Huis, Posts by Hui, VBA Macros

Learn two techniques to conditionally format the background of a chart based on some external value.

Continue »

## Custom Number Formats – Colors

Published on Feb 3, 2015 in Excel Howtos, Huis, Posts by Hui, Quick Tip

Did you know you can use Excel 95-03 Color Names or Color Numbers in your Custom Number Formats in all Excel versions up to an including Excel 2013?

This post will show you how.

Continue »

## Calculate Pi by throwing Frozen Hotdogs !

Published on Nov 28, 2014 in Huis, Posts by Hui, simulation, VBA Macros

Did you know you can Calculate Pi by throwing Frozen Hotdogs !
No ?
Learn how to calculate Pi by throwing Frozen Hotdogs with this Excel Simulation of Buffon’s Needle.

Continue »

## Formula Forensics No. 003b – Lukes Reward – Part II

Published on Nov 10, 2014 in Formula Forensics, Huis, Posts by Hui

A Formula based solution to extract records from a table that match a number of criteria.

Continue »

## Formula Forensics No. 037 – How to Count and Sum Filtered Tables

Published on Jul 23, 2014 in Formula Forensics, Huis, Posts by Hui

How to Count and Sum data from Filtered Tables

Continue »

## Hui’s Calendar Tool (as Borrowed from Chandoo)

Published on Apr 7, 2014 in Automation, Huis, Posts by Hui, VBA Macros

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

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

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 »

## We Want You – Revisited

Published on Jun 17, 2013 in Huis, Posts by Hui

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

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

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

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 »