Easily Filter Large Data Sets in Google Sheets

I use Google Sheets in my classroom a lot. I used to rely on combinations of the vlookup, importrange, and index/match functions to get information, but I've recently switched to using if and filter to return arrays of information from master spreadsheets. Using filter is nice because it takes multiple conditions and you can setRead More