Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

September 2009 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Adding Every Other Cell

    Jenny asks: Is there a quick way of adding every other cell ?, I have a column of about 250 cells, and I have to select them manually using Ctrl. Can you help ? Ihm replies: Another option to sum even/odd cells: =SUM(NPV({0,-2},A1:A250))/2 =SUM(NPV({0,-2},,A1:A250))/2 Use –A1:A250 and array-enter in case of blanks. If you’re like me, you’re probably saying WTF. Here’s [...] Read More...
    Filed under:

  • Multi-Column PivotTables

    J-Walk posted a link to the Top 101 Cities with the Largest Temperature etc…. The title is too long, so you’ll have to follow the link if you want the details. I wanted to see how this broke down by state. Here’s what I did. I brought the data into Excel using a [...] Read More...
    Filed under:

  • Software Trial Periods

    There’s a conversation at Contextures regarding Tableau software. One aspect of that conversation, the trial period, interests me and I want to comment on it here. I’ll be picking on Tableau, but it applies to quite a few software packages. Thirty days seems to be the most common trial period for software. I [...] Read More...
    Filed under:

  • Euler Problem 203

    Euler Problem 203 asks: The binomial coefficients nCk can be arranged in triangular form, Pascal's triangle, like this: 1 [...] Read More...
    Filed under:

  • International Excel Issues

    Hi all Together with Kirill Lapin and Hector Miguel Orozco Diaz I start with a webpage with International Excel problems. If you have suggestions/comments about the content that is on this page now or have problems with workbooks in different language versions let me know. We try to make this a collection of International Excel issues [...] Read More...
    Filed under:

  • Site Speed

    You probably noticed that the site has been unbearably slow lately. My host has made some changes, but I need more data points than just my own experience. If you can, use the comments of this post to let me know how this site’s speed compares to last week and how it compares [...] Read More...
    Filed under:

  • One Keyboard Shortcut

    The problem with posts about keyboard shortcuts is that I list ten or twenty of them and exactly none of them stick. So I’m just doing one. If you have to select a long column of data, using the mouse can take a while. And if I’m sitting behind you in your office trying [...] Read More...
    Filed under: ,

  • Custom Sorting

    In the above (obviously contrived) example, a company changed accounting systems. Any open projects at the time were converted to the new system, but were assigned new project numbers and names. Now the company needs to sort the reports by project number, but they want those jobs that have two different numbers to [...] Read More...
    Filed under:

  • Quick Counting in Excel

    There are several ways to count cells in Excel. Here are a few. 1. Subtract rows This is how our grandparents did it. If your data is in one column, you can compute in your head largest row - smallest row + 1. Watch out for those off by one errors. 2. Use QuickSum On the [...] Read More...
    Filed under:

  • Bar Is the New Pie

    Everyone is sick of talking about how pie charts suck. And whenever I do a charting post, it’s trouble. So this post is destined for failure. However, I was thinking about pie charts recently. I don’t have the disdain for pie charts that some do, but I generally agree with the [...] Read More...
    Filed under:

  • Golf Scores

    A couple of my golf buddies and I were debating the handicaps of a course we regularly play. Each hole of a course is handicapped 1 through 18 with 1 being the hardest hole and 18 the easiest. Handicaps are used to allow golfers of differing abilities to complete equitably. Because my [...] Read More...
    Filed under: ,

  • Office 2010 Icons

    Here’s Excel: See the rest at CyberNetNews. Read More...
    Filed under:

  • Where is my button that I add to the QAT of my workbook

    Hi all If you add a button to the QAT only for your workbook to run for example a macro it is possible that the button is gone when you reopen the workbook. Seems to be a SP2 bug. If you have this problem also in SP1 please let me know. I have add some info to reproduce [...] Read More...
    Filed under:

  • Searching multiple web resources

    Not quite Excel related but something I thought might be useful to others… Some time back I wrote a JavaScript based webpage that let me search multiple web resources from a single page. Recently, I enhanced the page to support the addition of new search resources “on the fly.” So, from this one page (http://www.tushar-mehta.com/search/web.htm) I [...] Read More...
    Filed under:

  • Euler Problem 119

    Euler Problem 119 asks: The number 512 is interesting because it is equal to the Base of its digits raised to some power: 5 + 1 + 2 = 8, and 83 = 512. Another example of a number with this property is 614656 = 284. We shall define a(n) to be the nth term of this [...] Read More...
    Filed under:
1 2 Next >
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.