Archive for September, 2015

List Differences in Two Cell Ranges in Google Spreadsheet

Another tip from my recent work in Google Spreadsheets. I had two columns of data and was looking for a way to display items that appeared in one column that didn’t appear in the other. The combination of the FILTER and MATCH functions is how I accomplished this. The FILTER function returns items from a […]


Access Data From Another Spreadsheet in Google Spreadsheets

I’ve been working with Google Spreadsheets a bit lately and have learned a few tricks. One such trick was learned when I had to find a way to have data in one spreadsheet automatically update based on data that’s in another spreadsheet. This turned out to be quite easy once figured out. Here’s how to […]