Search Contextures Sites
Excel Weekly News from Contextures Oct 16, 2012Find codes in a text string, watch for the table calculation bug, and other tips, in this week's Excel news from Contextures.
Find Text With INDEX and MATCH
Jodie asked for help with her worksheet, which had text strings in column A and codes in column D. Each text string contained one of the codes, and Jodie wanted that code to appear in column B.
This looked like an interesting problem that I could share on my blog, so I found an INDEX/MATCH formula that pulled out the codes from the text string.
Click here to see how I extracted the codes: Find Text With INDEX and MATCH
And read the comments too, to see how other people would solve the problem.
Table Calculation Bug in Excel 2010
Charles Williams has found a table calculation bug in Excel 2010, and describes the problem in his Excel and UDF Performance Stuff blog.
You can read the details here: Table Extension recalculation bug in Excel 2010 but not 2007
Introduction to MDX for PowerPivot Users
If you use PowerPivot in Excel 2010, you might want to learn more about MDX, so you can create better reports from your data.
Chris Webb is doing a series of MDX Intro tutorials on his blog, that you might find helpful. See the first two tutorials here:
Excel Developer Meet Up at Canary Wharf
If you're in London, and would like to meet a few Excel developers for a friendly drink tonight, get in touch with Simon Murphy on his Smurf on Spreadsheets blog.
He's organizing a social evening for tonight -- Tuesday, October 16th -- at 7 pm at the All Bar One in Canary wharf.
Here is the link to Simon's blog post: Rad Dev drinks next tue in Canary Wharf
Recommended Excel ToolsThey aren't free, but these Excel tools are a worthwhile investment, so please click on the links to take a look at their features, and decide if they're right for you.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
- Excel Pivot Table Intro Course
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2014
All rights reserved.