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