Home Excel Formula

Excel Formula

Advanced Excel Formulas.

Example showing how to sort each row individually in Excel using a LAMBDA formula

Sort Each Row Individually in Excel Using a LAMBDA Formula

Prashanth KV 0
Sort data by field label selected from a drop-down list in Excel

Sort by Field Labels Using the SORT and XMATCH Combo in...

Prashanth KV 0
Example of inserting two blank rows in a table in Excel

Dynamic Way to Insert Blank Rows in a Table in Excel

Prashanth KV 0
Example of inserting empty cells between values in a column in Excel using a dynamic array formula

Insert N Empty Cells Between Values in Excel (Dynamic Array)

Prashanth KV 0
Extract the last N non-blank rows in Excel dynamically

How to Extract the Last N Non-Blank Rows in Excel Dynamically

Prashanth KV 0

Count Consecutive Duplicates in Excel (Dynamic Array Formula)

Prashanth KV 0
Filtered results showing the top N T-shirt brands per store in Excel using the FILTER and COUNTIFS functions

Filter Top N per Category in Excel (Using FILTER & COUNTIFS)

Prashanth KV 0

Rank per Group in Excel

Prashanth KV 0

Real-Time Excel Filtering Using Combo Box & FILTER Function

Prashanth KV 0
Example of sorting names in ascending order by last name in Excel

Sort Names by Last Name in Excel Without Helper Columns

Prashanth KV 0
123...10Page 1 of 10