With the new Excel CHOOSEROWS function, it's easy to extract the top / bottom rows of your data. Let's discover how to build it.


The COUNTIFS function in Excel works like a filter. It returns the number of rows you have in a worksheet based on one or more criteria.


The COUNTIF function returns the number of rows within a range according to a criteria. Many situations are possible.