All articles in 'Huis' Category
Learn two techniques to conditionally format the background of a chart based on some external value.Continue »
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 »
Did you know you can Calculate Pi by throwing Frozen Hotdogs !
Learn how to calculate Pi by throwing Frozen Hotdogs with this Excel Simulation of Buffon’s Needle.
A Formula based solution to extract records from a table that match a number of criteria.Continue »
How to Count and Sum data from Filtered TablesContinue »
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 »
Learn how to Count Text, Blanks and Non-Blank cells with this Countif() Quick TipContinue »
Chandoo.org produces it’s Second Excel MVP.Continue »
How to Solve an Equation in ExcelContinue »
Use Excel to extract matching words from a list of words from a cell containing a sentence into individual cells in the order they existContinue »
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 »
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.