excel small

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 get nth Match with One Criteria using INDEX/MATCH

This post will guide you how to get nth match based on one criteria with INDEX and MATCH in Excel. In the previous post, we used one excel formula to get the position of the nth occurrence of a value based on one criteria, at this moment, we can also use it in the new… read more »

Excel SMALL Function

This post will guide you how to use Excel SMALL function with syntax and examples in Microsoft excel. Description The Excel SMALL function returns the smallest numeric value from the numbers that you provided. Or returns the smallest value in the array. It also can be used to get the nth smallest value from a… read more »

Sidebar