Dailydoseofexcel - dailydoseofexcel.com - Daily Dose of Excel
General Information:
Latest News:
Pegged 10 Aug 2013 | 12:19 am
Can’t a guy sort a couple hundred rows?
Calculating the Number of Unique Items in a Delimited String 7 Aug 2013 | 05:40 pm
This is a guest post by David Hager. You can learn more about David on LinkedInd There has recently been interest in handling row data that contain delimited strings. An elegant solution to split a d...
Recent Files and Places Search 6 Aug 2013 | 05:30 pm
I love what Excel has done to the list of recently opened files. It went from up to nine files to up to 50 files. You can pin certain files so they never leave the list. Every item on the list has a k...
Looping through PivotItems that Don’t Exist 30 Jul 2013 | 05:30 pm
I have some code that creates a journal entry import file based on a pivot table. It loops through the PivotItems and reads the DataRange.Value2 property. It’s nothing fancy or particularly complicate...
Averaging Best 4 of 5 Golf Scores 25 Jul 2013 | 05:00 pm
Here’s part of a spreadsheet for a golf league. The formula in AA is just an AVERAGE(), but the one in AB is a little more interesting. It looks like this: {=IF(COUNT(B2:Z2)<5,AA2,(SUM((Z2:INDEX(A2:...
What’s New for Excel 2013 Developers 18 Jul 2013 | 06:14 pm
What’s New Apps for Office in Excel Microsoft Excel 2013 brings the web to Excel. New apps for Office offer a wealth of interesting, new scenarios and solutions in an easy-to-use environment for dyn...
File Path and Name for Links 16 Jul 2013 | 05:00 pm
Unlike many people with whom I work, I almost never email a workbook. Instead, I save it to an appropriate place on the server and email the link. This seems to confuse the hell out of some people, bu...
Generate random numbers in MS Excel 8 Jul 2013 | 10:44 am
A common requirement is to generate a set of random numbers that meet some underlying criterion. For example, a set of numbers that are uniformly distributed from 1 to 100. Alternatively, one might wa...
VBA Best Practices That I’ll Never Do 2 Jul 2013 | 05:30 pm
I don’t know if these are really “best practices” or if I’m just making them up. I know I heard them somewhere, but that doesn’t make them universal by any means. Also, I generally agree with all of t...
How To Be Great at Excel 25 Jun 2013 | 05:30 pm
You might think that this point will be about hard work and determination. It’s not. You might think it’s about acquiring the most knowledge. You’d be wrong. I don’t care if you’re the hardest working...
