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

October 2010 - Daily Dose of Excel

Sort by: Most Recent | Most Viewed | Most Commented

  • Bulging Squares

    I found this Bulging Square illusion on my iPad, and then I found that Excel Hero had already done it as The Bulging Checkerboard. But Daniel did it as a chart, no VBA. Here is my interpretation with VBA, no chart. The first step was to make the cells square. Cell dimensions are [...] Read More...
    Filed under: ,

  • Pairwise Comparison

    Thanks to J-Walk for the terminology “Pairwise Comparison”. Had I known it was called that I could have saved a lot of wasted Googles. In Subjective Sorting, I used a QuickSort algorithm and human input to order five movies from 1988. It worked because 1) I was the only one providing input, 2) my [...] Read More...
    Filed under:

  • Showing an Excel worksheet in HTML (i.e., on a web page)

    For a version in a page by itself (i.e., not in a scrollable iframe as below) visit http://www.tushar-mehta.com/publish_train/xl_vba_cases/1031_excel_worksheet_to_html.shtml Read More...
    Filed under: ,

  • Off topic: Facebook Social Engineering?

    I’m not a member of Facebook. I was recently invited to join by email from a man I don’t know. His subject for the email was “Check out my photos on Facebook.” The stranger included inside his email pictures of eight individuals and one couple. Of the 10 people, 2 are [...] Read More...
    Filed under:

  • Financial Check Up

    I recently read this post at millionairemommynextdoor.com: Q: Pam asks, “After my portfolio value dropped by 40%, I panicked and pulled out of the stock market. I have $150,000 sitting in my savings account, earning squat. I know I should put it back to work, but with the state of our economy, I don’t know what [...] Read More...
    Filed under:

  • 33 Miners

    The CNN banner said “21st Miner Rescued.” To be on topic, I wondered how Excel might automate that. You need a simple algorithm that checks the count mod 10 and the count mod 100. If i mod 10 = 1 and i mod 100 11 then the appropriate suffix for i [...] Read More...
    Filed under:

  • Subjective Sorting

    I have a list of objects. Oh, I don’t know, let’s say it’s the top 5 grossing movies from 1988. I want to rank these movies by how much I like them. To do this, I want to compare only two movies at a time until they’re in the proper order. Any comparison [...] Read More...
    Filed under:

  • Chat about Office 2010 and Windows 7 on Oct 14th with MVPs

    This is a first time event for me so I have no idea of what to expect. I volunteered and Microsoft took me up on my offer to be one of the Excel panelists. The blurb from Microsoft: Would you like to learn more about the cool new features in Office 2010 and Windows 7 and [...] Read More...
    Filed under: ,

  • TableMaker 2.0

    Dick very recently put up a function that takes an Excel range and whips up some HTML to create a table. I loved that idea, and I asked if I could flesh it out. With Dick’s green light, I created a Sub() that captures each cell’s font family, font style, and font color, [...] Read More...
    Filed under: ,

  • Failed Charting

    I wanted to make a chart that told the following story: Although the top athletes make a lot of money and those are the athletes you see on TV, if you care about how much money you make, you’ll have better odds becoming an accountant. To tell this story, I thought I would show the average [...] Read More...
    Filed under:

  • MVP 2010

    According to Microsoft, I’m awesome. Who am I to disagree? I’ve actually been an MVP for a few years, but the stackable acrylic award only started last year. I’m not sure when I was first awarded, but it was around the same time as Debra and Jon, so maybe they remember. There was a time [...] Read More...
    Filed under:

  • Excel Converts to Date When Opening CSV

    This is an age old problem that I’ve mostly ignored. When you have something in a CSV that could be a date, like 2-1 could be February 1st, Excel “helpfully” converts it into a date. This problem isn’t unique to Comma Separated Values (CSV) files. Excel will convert 2-1 entered into a [...] Read More...
    Filed under:

  • Cleaning Data

    Are there any good utilities for cleaning up Excel data so that it could be put into a database? A quick search didn’t reveal anything of note. I think one problem is that data sets, and the problems with them, are so varied that it would be difficult to develop a general purpose [...] Read More...
    Filed under:
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.