gregg's blog

Microsoft’s Excel 2007 added an amazing new command not present in previous versions, Remove Duplicate Data (its just right of center on the Data ribbon).

Removing duplicate data before 2007 involved either Visual Basic programming or a manual comparison after sorting the data.  Both solutions are time consuming (and error prone in the case of manual comparison).

Remove Duplicate Data can search unsorted tables with thousands of rows in less than a second, pulling any duplicates that match in every column, or in a user defined group of columns.

I got an ASUS eeePC 900A for $150 and have been playing with it.

With only a 4 GB SSD "hard drive" it doesn't have a large capacity.

I can see why so many have been returned and show up now as refurbished units, after about half the updates that were downloaded automatically when I booted the machine, it was out of disk space so the rest of the updates wouldn't install (and the error message wasn't clear why, just it wouldn't work).

I reformatted the SSD and installed an eeePC Ubuntu configuration with Open Office 3.1 and have about 900MB left.

I got a DXG 581V in February, just in time for a trip to Bangkok!

It is amazing.  1080p, and so tiny…

DXG 581V

I saw a Google Blog post about their new toolbar labs.

Since I love the Google Toolbar in Firefox and less frequently Internet Explorer, I clicked on the link while in Firefox.  I got an interesting message so I opened Google Chrome and tried the same URL, that’s when I got this:

My last post on Using Excel to Create HTML, I discussed using Excel to automatically create HTML for a friend Cinda.

I use a PC (actually a network of PC’s, I use more than one computer) running Windows XP.

Cinda uses a Mac.