Home Excel Formula

Excel Formula

Advanced Excel Formulas.

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

Hyperlink to Jump to the Last Used Row in Excel

Prashanth KV 0
Finding the Cell Address of the Last Value in the Last Used Row in Excel

Find the Last Used Row’s Last Value Address in Excel

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