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

Linked Blogs

Sort By: Most Recent | Most Viewed | Most Commented

  • Left Looking Lookups

    OR: The problem with VLOOKUP. Wikipedia gives us a table of birthstones, and I think just because it’s Wikipedia, there’s a trailing space after every entry. Pasted into a spreadsheet, the table looks like this:   A B C D E 1 Month  Traditional Birthstone(s)  Modern Birthstone(s)  Mystical Birthstone  Ayurvedic Birthstone  2 January  Garnet  Garnet  Emerald  Garnet  3 February  Amethyst  Amethyst  Bloodstone  Amethyst ...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Sep 10 2010
    Filed under:

  • Office 2010 PIA Redistributable available for download!

    I know that some developers have been waiting to get access to Office 2010 PIA Restributable. Although we can create our own IA some developers prefer to use the officially PIA from Microsoft. Today when I checked it up I was pleasant surprise to find out that the PIA package is now available for download. [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Thu, Sep 9 2010

  • True or false, IF provides the answer

        Today’s post is brought to you by Frederique Klitgaard. Frederique is a writer on Office.com   It’s easy to understand why the IF function appears in the top 10 list of popular Excel functions. It’s a versatile function that can be used for all sorts of tasks. For example, this function can save you a lot of time when you need to grade a stack of papers. It quickly turns a long list of test scores into grades without having to do any of the math. It can also instantly determine...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Wed, Sep 8 2010

  • Download our free Office 2010 migration guides

    Over on the The Microsoft Office Blog there is a post that links to some migration guides for Microsoft Office 2010: “Whether you're coming from an older version of Office and just want to find the most frequently used commands in a program, or you're entirely new to Office and want a quick overview of how the ribbon works and how to get to the most important things, each guide provides helpful information that we've based on direct feedback from you — our customers.” Read more and download...

  • Building a self-sorting list (Part 2)

    In Part 1 we ended up with Column D, a sorted list. One criticism was the many times we were counting the numbers in a column. We should improve it and only count once. Via Insert/Name/Define define Count_BB to =COUNT(Sheet1!$B:$B), and then select Columns C:D, and “Replace All” COUNT(B:B) with Count_BB. [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Sep 6 2010
    Filed under:

  • Building a self-sorting list

    I haven’t posted in a good while. I’ve done over half the Euler problems, but haven’t had the time to research the high-numbered ones considering I might even understand them. Now that I’ve retired from my second career, and my third is only part-time, maybe I’ll get back to it. Today is [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Fri, Sep 3 2010
    Filed under:

  • Setting a Base Directory

    If you want your Excel app to default to a specific directory when opening or saving files, see Changing the Current Directory. Be sure to read the comments. I have a slightly different situation. I want my app to open to a specific directory that will give me easy access to sub directories. [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Sep 2 2010
    Filed under:

  • Count Active Customers

    Jake wants to know, given an active date and an inactive date, how to count the customers that were active in a certain time period. The ones we want are highlighted in yellow. The formula is =COUNT(D2:D21)-SUMPRODUCT(($C$2:$C$21>=D25)+($D$2:$D$21< =C25)) It’s easier to figure out who is not active during that date range and subtract it from the total. [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Wed, Sep 1 2010
    Filed under:

  • =VLOOKUP (uhh…now what?)

    Today’s post is brought to you by Anneliese Wirth, a writer on Office.com. On Office.com , the term “VLOOKUP” frequently bubbles up in our list of high-volume search queries. My job is to figure out why this is and what specific information people are actually looking for when they type “VLOOKUP” into the search box in Help or on our web site. The “VLOOKUP” query appears to represent a bunch of different questions. Certainly, one of the main ones has to do...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Tue, Aug 31 2010
    Filed under: , ,

  • Dymo LabelWriter Part II

    A couple of weeks ago, I posted some code to print labels on a Dymo LabelWriter 450. I wanted to post the finished code because it has a few more tricks in it. Function PrintBoardFileLabel(ws As Worksheet) As Boolean     Dim bReturn As Boolean     Dim vaPrinters As Variant     Dim i As Long     [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Tue, Aug 31 2010
    Filed under: , ,

  • Abbreviating Company Names

    Last week I was creating file folder labels with my new Dymo LaserWriter 450. The information on the folder label is serial number, part number, company name, and purchase order. Normally, this works great. However, I ran into one on Friday with a 30 character part name and a 29 character company [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Mon, Aug 30 2010
    Filed under:

  • Using SQL Server Compact Edition Database with Excel

    Introduction Often we see questions about acquiring data from various data sources like SQL Server Databases, MDBs, Excel and text/xml-files in webbased Q&A forums and in blogs. But what I see very rarely is any discussions on how to retrieve data from Microsoft SQL Server Compact Edition (SSCE) databases and to populate Excel worksheets with [...] Read More...
    Posted to XL-Dennis's Blog by VSTO & .NET & Excel on Sun, Aug 29 2010
    Filed under: ,

  • Bushy Trees

    A favorite peeve of mine is code with “bushy trees.” I first saw this phrase in Kernighan and Plauger’s Elements of Programming Style. Recently, I saw some code that checked if a RefEdit control referred to a single cell that contained a non negative integer. I cleaned up the formatting some since the original [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Sat, Aug 28 2010
    Filed under: ,

  • You Asked: What the heck is Scroll Lock

      This week’s post is written by Amy Miller. Amy is a writer for Office.com. She’s written and edited content for Excel, Access, OneNote, and InfoPath.   Imagine you’re working in a spreadsheet and you innocently press the arrow keys on your keyboard to move to another cell, but instead of moving to another cell, the entire spreadsheet moves. You may have asked yourself, what the heck just happened, and how do I make it stop? Lucky you. You’ve encountered that pesky little problem called...
    Posted to The Excel Team Blog by Microsoft Excel 2010 on Wed, Aug 25 2010
    Filed under: ,

  • A Hundred Thousand Name Managers!

    Hi folks, Many of the regulars here probably know the Name Manager utility, which Charles Williams and I created and give away for free on our websites. Rumour has it this is one of best tools ever built for the Excel developer. I won’t argue with that! Anyway, as I was looking at my web stats today I [...] Read More...
    Posted to Daily Dose of Excel by Daily Dose of Excel on Thu, Aug 19 2010
    Filed under: , , ,
1 2 3 4 5 Next > ... Last »
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.