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

April 2009 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Calculating Wind Direction

    Tom asks: I have three values with wind direction at differrent altitudes. A1: 020, A2: 2000 feet, B1: 010, B2: 5000 feet, C1: 350, C2: 10000 feet and I would like to forecast the wind direction for D2: 3000 feet. I’ve tried the forecast function but it goes haywire with the change from 010 to 350 degrees. I made [...] Read More...

  • Data Sets

    I like finding data sets on the internet. Like at mathforum.org and other resources at mathforum.org. Now we can answer the age-old questions like, Where do women outlive men by the largest margin? I guess they kept the women-folk away from Chernobyl. It does raise the question of why I can’t prevent Bangladesh’s [...] Read More...
    Filed under:

  • Euler Problem 80

    Euler Problem 80 asks: It is well known that if the square root of a natural number is not an integer, then it is irrational. The decimal expansion of such square roots is infinite without any repeating pattern at all. The square root of two is 1.41421356237309504880..., and the digital sum of the first one hundred decimal [...] Read More...
    Filed under:

  • Related Sheets Stack

    In Previous Sheets Stack, I created a historical list of sheets visited on the right click menu for easier navigation. After reading the comments, I decided to change the whole approach. Now I show related sheets (which I define) in a userform. Related Sheets I'm dealing with inventory assemblies, so the relationship is already defined. [...] Read More...

  • Previous Sheets Stack

    I have a workbook with 131 worksheets in it (one for each inventory item). It is a terrible design, but it's a non-trivial task to make it right, so I haven't done it yet. Instead, I'm making little macros to make working in this monstrosity livable. I have a macro to build [...] Read More...
    Filed under: ,

  • VLOOKUP on Two Columns

    Here are three ways to lookup a value based on two columns. Let’s start with this random data: And let’s say that we want to lookup the autonumber value for Carlo. Not the Carlo in Seaford, but the Carlo in Westwood. SUMPRODUCT With ‘Carlo’ in E2 and ‘Westwood’ in F2, use =SUMPRODUCT(($A$2:$A$16=E2)*($B$2:$B$16=F2)*(C2:C16)) If you have more [...] Read More...

  • The Wire: 100% Finished

    From Breakfast at Nancy’s J-Walk finished watching all five seasons of the Wire last month. He graciously sent me the DVDs in exchange for three seasons of Arrested Development. Now Nancy and I have finished the Wire and are looking for a trade. I got two recommendations for the Wire: Curtis, a regular at j-walkblog.com [...] Read More...
    Filed under:

  • VLOOKUP

    As you know, the fourth argument of the VLOOKUP worksheet function determines whether VLOOKUP finds an exact match or an approximate match. If you set the last argument to False, and there is no exact match in the lookup list, the formula will return #N/A!. In Excel 2003, the best way to capture this error, [...] Read More...

  • Office 2007 SP2

    Hi all Read the information about the changes in Office 2007 SP2 on this page: http://blogs.technet.com/office_sustained_engineering/default.aspx Regards Ron de Bruin Read More...
    Filed under:

  • Inventory Freight Calculation

    To account for freight on incoming inventory, I allocate the freight charges proportionately over the inventory items by total value. Quickbooks doesn’t have a way to handle that, so I use a simple Excel spreadsheet to do the calculation. The last entry is always the freight (or handling or whatever I want to distribute). [...] Read More...
    Filed under:

  • Office “14” – Microsoft Office 2010

    Hi all, The word is out! We now have an official name for Office 14 and some sort of a date too. Regards, Jan Karel Pieterse Read More...
    Filed under:

  • Historical U.S. Tax Rates

    I heard a lot of news about ‘tea parties’ going on yesterday. If you don’t know, tea parties are supposed to mimic the Boston Tea Party, where New Englanders complained that they were paying tax, but had no say in government, i.e. taxation without representation. That got me wondering why people would be participating in [...] Read More...
    Filed under:

  • OfficePalooza

    via Tony’s Microsoft Access Blog OfficePalooza appears to be an opportunity to sharpen your VBA skills. OfficePalooza is a two-week event (April 20 – May 1, 2009) that is open to just about everyone around the world. (Technically we’re supposed to be targeting what our marketing team likes to call “Advanced Business Users,” but even if you [...] Read More...
    Filed under:

  • Opening Outlook Attachments

    I don't know why there's not an easier way to open attachments from an email I'm viewing, but there's not. I made stole some VBA code to do the job. First, I borrowed JP's code to Open Any Email Attachment From Outlook. Then I changed a few things. I only wanted to open [...] Read More...
    Filed under:

  • The Famous Nick Hodge

    Nick Hodge has been getting a lot of press lately. First, he recently appeared on J-Walk’s blog. More recently, he was featured on the MVP blog. I’ve been reading that MVP blog since it started and finally I know somebody. I guess I can quit reading it now. Good job, [...] Read More...
    Filed under:
1 2 Next >
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.