Author Archive

Palindrome: – A palindrome is a word, phrase, number, or other sequence of units that can be read the same way in either direction, with general allowances for adjustments to punctuation and word dividers (“Wikipedia”).

This week in Formula Forensics we’re having a look at determining if a cell contains a palindrome.

Zebra Stripes and Checker Boards

This week in Formula Forensics I’m taking a break from Array Formulas to have a look at some Zebra Stripes and Checker Boards.

No, I haven’t gone crazy, although some may argue that point.

More specifically were going to take a look at, Zebra Stripes and Checker-Board Conditional Formatting.

Congratulations Chandoo.org on reaching 1,000,000 page hits in November 2011.

Hui…

.
.
.
.
.
.
.
This is the Forth post in Chandoo’s, Formula Forensics series.

Last week Luke showed us how to extract a sorted list according to a criteria from a larger list
and he analysed a formula to solve this problem

This week we look at Fred’s Problem…

How do I simplify a very long formula?

Maintenance on the 18 month old, Data Tables, Monte-Carlo Simulations and Fractals in Excel – A Comprehensive Guide has been completed.

Today we publish what is hopefully the First of many posts by guest author Luke M. it is also the Third post in the Formula Forensics series, which has now moved to a regular and new Thursday slot ?

Luke has taken up Hui’s and 3G’s challenge of explaining how the technique he regularly uses on the Chandoo.org Forums for extracting individual records out of a group.

Today Luke tells us how to extract a list of items from a larger list according to some criteria.

Formula Forensics # 002 – Joyces Question

This is the second post of a new regular weekly series at Chanoo.org, Formula Forensics, where we will examine how a formula works from the inside out with a worked example to help you understand its formation.

Last week we looked at Taruns problem and analysed a formula to solve his problem

This week we look at Joyce’s Problem…

Normally when responding to a Post or a Forum Post you will see a plain old text response like

Occasionally you may see some Bold or Code highlighted like

How is this done and what else can I do to add value / pizazz to my posts ?

This post examines a quick technique for developing Custom Number Formats for Cells, Charts or any other Number location in Excel.

Chandoo is off on Holidays and once again thrown me the keys to Chandoo.org.

So this week we’re going to:

• Pull apart an Array Formula and see what’s under the hood;
• Have a look at a technique for quickly developing Custom Number Formats &
• Look at how we can use HTML Codes in posts at Chandoo.org to spice up your questions and answers.

Today is Tarun’s Problem

“I have got multiple names in each row and would like to have what name is repeated maximum number of times and how many times?”

Today we pull apart an answer to this question and see how it works.

Hi All. I am about to head off on holidays for a couple of weeks during which time I will only have limited internet access and won’t be helping out here at Chandoo.org or at the ExcelHero Academy whilst away. I thought I may leave a few words and a Challenge for everyone. History In […]

Do you enjoy printing complex spreadsheets with multiple pages with different print ranges and different setups on each page for different people who have different requirements ?

If the answer is No…

This post may save your day and change your life.

Last week I introduced the technique of using custom Number Formats for Chart Axis labels.

Today I present a few more alternative layouts including Chart Series Data Label Formats.

A few weeks back, John asked a post question, “ How can I add a £ to the 80 on a Chart axis and leave the rest of the numbers plain numbers ? ”

Custom Number Formats, That’s How.

Two weeks ago we asked you what you wanted to see at Chandoo.org and you responded.

We have had 71 responses giving us 101 ideas to date.

Here are the results…