The most recent Job Gap report was recently released by the Alliance for a Just Society. It is the latest in a string of Job Gap studies for which I was the primary number-cruncher. The report looks at the availability of job openings that pay a living wage in five states – Colorado, Idaho, Montana, [...]
Let’s say you have an Excel file with names and sign-in information from some events you hosted over the past year. Some of the attendees came to more than one of your events. You want to send out email invitations to your next big shindig, but you don’t want to accidentally send more than one [...]
This post builds upon “How to merge datasets in Excel or OpenOffice’s Calc.” A reader, Tina, asked “What if you have more than one column to lookup to get the match value?” This post tries to answer that question. Merging two datasets requires that they share at least one column in common. If this is [...]
Here is the scenario You have two related datasets in Excel or OpenOffice’s Calc. One is a list of names with phone numbers, and the other is a list of names and email addresses. The two datasets have a unique id in common (like a Social Security number). You want to merge the two of [...]
