Data Filtering

Once you understand how to use filter function in Excel, it becomes hard to go back to old formulas or manual filters. I still remember opening a sheet and realizing that the data could spill automatically, adjust itself, and respond to changes without rewriting formulas. That is where dynamic arrays and dynamic data really start … Read more