All articles in 'Huis' Category
Find the Cell Address for a value from a 2D or 3D Range
(2D & 3D Reverse Lookup)
Learn how to find which worksheet a max or min value occurs on using this neat formulaContinue »
What functions you believe Excel is missing?Continue »
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 »