Рет қаралды 135
Online course: Excel 365 for Busy People
www.udemy.com/...
Corporate training for Excel and other Microsoft and Adobe applications:
ComputerTrainin...
Between the Sheets, Episode 44: Combining Excel's Take and Filter Functions
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.