I have two separate marketing lists on spreadsheets, both of which were originally opt-in, but have been residing on different systems - System A for email marketing and System B for SMS marketing. List A has the users' email addresses, cellphone numbers and names. List B just has the users' cellphone numbers (plus a column called "unsubscribed" for those people who. I want to combine the two spreadsheets to create one spreadsheet while keeping the column called "unsubscribed" so I know which people to keep permanently removed. Can you advise me on how to synchronise these two spreadsheets using the cellphone number as the common data? Thanks!
Question about splitting data into columns: I have one column of data that I'd like to split into seven separate columns. A typical, complete row in the column looks like "mefi:1,ask:3,meta:2,projects:5,jobs:5,music:6,irl:4" where the number values can be anywhere from 1-6. The problem is that if any one or more of the seven subsites are left unanswered, the entire value is missing (there is no "[subsite]:0" or "," as a placeholder). Consequently, separating the column into seven distinct columns using the comma as the separator causes the data to fall/shift into the wrong output columns if any one or more of the seven subsite categories are missing. How can i fix this? [more inside]
Former excel magician attempts to use Google spreadsheets, fails. It should be easy to make a function that can tally a monthly total from a column of dates and a column of numbers, right? [more inside]
I have an xls file I got from a survey I created on Google docs. Now I want to make it pretty without copy-pasting every bloody cell into an Indesign document… [more inside]
Which one is right, Google or Excel? [more inside]
I have hundreds of text strings entered through a form in a Google Spreadsheets which look like 4*3 9*2 17*3 22 37*4 52. I can easily substitute " " for "+" and concatenate a "=" in front =4*3+9*2+17*3+22+37*4+52. Now I have a text string which looks like a formula but isn't one. How can I make Google Spreadsheets interpret this string as a formula? [more inside]
I want to be able to filter my data in Google Docs Spreadsheets like the Data > Filter > AutoFilter function in Excel 2003. [more inside]