Between the Sheets — Excel podcast episode 44: combining the Take and Filter functions
In partnership with Experts Exchange. The Take and Filter functions are both new in the 365 editions of Excel. By combining them in a formula, you can extract a bunch of first or last rows or columns from a table that meet specific criteria.