Menu
Author Archive
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 »
{ 97 Comments }
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 »{ 17 Comments }
Formula Forensics No. 035 Average the last 3 values greater than 0
Published on Oct 3, 2013 in Formula Forensics, Posts by Hui
Learn a technique to Average the last 3 values from a range where the values are greater than 0
Continue »
{ 16 Comments }
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 »{ 42 Comments }
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 3.)
Published on Jul 19, 2013 in Formula Challenges, Posts by Jeff
Welcome back to yet another gripping episode of “When good formulas go GREAT”. We’re working up the singles charts to the number one hit “Formula Challenge 001 – Return everything in string after first block of numbers” By way of a quick refresher, this formula challenge calls for a formula to return a substring from […]
Continue »{ 46 Comments }
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 2.)
Published on Jul 17, 2013 in Formula Challenges, Posts by Jeff
Today we look at the third place winner from our inaugural Formula Challenge, a neat solution provided by Sajan.
Continue »{ 43 Comments }
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 1.)
Published on Jul 16, 2013 in Formula Challenges, Posts by Jeff
This new series introduces a new author to Chandoo.org, Jeff.
Jeff will pose a number of Excel based Formula Challenges and then explain how some of the solutions work in a manner similar to the Formula Forensics series.
In this first post of the series we look at how to extract a string from the right of a block of Numbers in a larger string.
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 »{ 19 Comments }
Formula Forensics No. 032 – Creating Dynamic Charts with Non-Contiguous Data
Published on Dec 4, 2012 in Formula Forensics, Posts by Sajan
There are many web pages devoted to Excel Charts and there are many web pages devoted to Creating Dynamic Ranges, but a lot of these suffer when the data is poorly organised or non-contiguous.
Today we look at a Technique for Creating Dynamic Charts with Non-Contiguous Data.
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.
Your the production manager and have a need to schedule uneven resource across uneven requirements, how can you do that?
Well today we’ll look at Resource Allocation and Scheduling using Excel to do the hard work
{ 17 Comments }
Formula Forensics No. 030 – Extracting a Sorted, Unique List, Grouped by Frequency of Occurrence
Published on Oct 4, 2012 in Formula Forensics, Posts by Sajan
Today at Formula Forensics, Guest author Sajan shows us how to extract a sorted, unique list of items, displaying the most frequently occurring items first, while restricting the output based on some additional criteria.
Continue »
