All articles in 'Posts by Jeff' Category

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 »

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
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 1.)

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 »

We cant Cure Cancer, But we can Cure this Medicare Chart [Chart Busters]

Published on Jul 24, 2009 in Charts and Graphs, Posts by Jeff
We cant Cure Cancer, But we can Cure this Medicare Chart [Chart Busters]

In this installment of Chartbusters, we take a look at a poorly constructed choropleth of medicare reimbursements in US and suggest cure for it. The post is from our Guest Buster – Jeff.

Continue »