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
Save time with our "Done For You" Excel products.
- Pivot Power Premium Add-in - Time-saving tools for pivot table users
- Data Entry Popup Kit - Quick and easy data entry with a popup list
- Data Entry Search Popup - Enhanced data entry popup, with Search box
- Excel Tools Add-in - Make instant backups, sheet list with links, much more
- More Excel products from Contextures
Note: I am an affiliate for the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2019
All rights reserved.