excel formula examples

How to find the nth Largest Value

In the previous post, we talked that how to get the nth smallest value in a range and how to get the relative value of the same row of the nth smallest value in a range or array. And this post will guide you how to get the nth largest value in a range in… read more »

How to Find the nth Smallest Value

This post explains that how to get the nth smallest value in a single column, or single row or an array list in excel. How to extract relative value in the same row based on the position of the nth smallest value in a single column. Find the nth Smallest value You can use the… read more »

How to Create an Array of Numbers

This post explains how to return an array of numbers using an excel formula in excel. Create an Array of Numbers If you want to create an array of numbers, you can use a combination of the ROW function, the INDIRECT function or OFFSET function or INDEX function or MIN function to create a new… read more »

Three Ways to Get the Last Row Number in a Range

This post explains that how to get the last row number in a range or a table in excel. Sometimes, you want to know the last row number for a excel range. The below will guide you how to get the last row number in range using excel formula through the following three ways: Get… read more »

Three Ways to get the First Row Number in a Range

This post explains that how to get the first row number in a range in excel. This post will guide how to get the first row number of a range via the below three ways: Get First Row Number using the ROW Function Only Get First Row Number using the Row Function within MIN Function… read more »

How to Find the Relative Position in a Range or Table

How to get the relative row numbers for a range or table. How to find the relative row position of one Cell value in a specified Range or table. This post will guide you how to get the relative position of all rows in a range or table in excel. And how to get the… read more »

Sidebar