Search Contextures Sites

 

 

Contextures
Newsletter Index

 

 

 

 

30 Excel Functions in 30 Days

 

 

 

Contextures News

Excel Weekly News from Contextures Oct 16, 2012

 
Find 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:

Introduction to MDX for PowerPivot Users, Part 2: Basic Sets

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 Tools

They 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.

Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.