All articles in 'Posts by Jeff' Category
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 2.)
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.)
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]
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 »