Automatically identify rows with an empty attribute

In a social.answers forum, Sue asked if there was a way to automatically copy rows that had a blank value in a particular column. See http://social.answers.microsoft.com/Forums/en-US/excslcreate/thread/dd6af3c8-5801-43c0-86f4-a668cdc3fd85 As a fan of using SQL, particularly through MS Query, I came up with the following. Suppose we have a table with 3 columns, with a few empty values …

Continue reading ‘Automatically identify rows with an empty attribute’ »

Regular chart version of a sparkline

In one of the social.answers.microsoft.com web forums (Microsoft’s replacement for the newsgroups no longer hosted on its own server) someone wanted to see a regular chart version of a sparkline when s/he clicked on the cell. I thought that was an interesting idea since one can see much more detail in a large object than …

Continue reading ‘Regular chart version of a sparkline’ »