Traditionally, filtering a dataset by multiple AND/OR conditions involved use of the Advanced Filters feature. While menu-driven, Advanced Filters can be difficult to manage and applies filters directly over the source dataset, which can be undesirable for manipulating and collaborating on the data. A recent alternative for building complex feature is the FILTER() function, one … Continue reading How to filter a dataset by one or more criteria using Excel formulas