Archive for September, 2015

Comments Off on List Differences in Two Cell Ranges in Google Spreadsheet

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


Comments Off on Access Data From Another Spreadsheet in Google Spreadsheets

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