Tag Archives: Excel

How to merge data in an Excel or Calc spreadsheet, part two

This post is a continuation of an earlier one detailing 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 is a response to that question. A merge of two datasets requires at least one [...]

Posted in spreadsheets | Also tagged , , , , , , , , , , , | 1 Comment

Using sign-on letters to petition legislators

If you are looking to write a sign-on letter to a legislator that your members and supporters can sign on to, there are several options available. Below are some options I have encountered that allow you to petition legislators.

Posted in e-activism | Also tagged , , , , , , , , , , , , | 5 Comments

How to merge data in an Excel or Calc spreadsheet

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 [...]

Posted in spreadsheets | Also tagged , , , , , , , , , , | 31 Comments