All articles with 'code' Tag

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.

Houston, We’ve Had a Problem!
In the initial emails requesting a solution to yesterday’s Formula Forensics, Chandoo’s solution, although Technically correct, Didn’t work ?
This post looks at the problem and what was wrong with the data causing the error.

Learn how you can write your own twitter client using Excel. All it takes is excel, internet connection and 5 minutes of spare time.