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