## Get nth Match with INDEX, MATCH, and SMALL in Excel

We can use the combination of INDEX, MATCH, and SMALL functions to find the data that is in the nth position of a…

We can use the combination of INDEX, MATCH, and SMALL functions to find the data that is in the nth position of a…

Adding horizontal and vertical lines in particular cells of your data set can improve the readability of your data. This tutorial explains how…

Standard text boxes in Excel are static. It means the values in them do not change until or unless you change them. This…

An Excel formula that uses cells from different worksheets has linked cells. You may need to go to linked cells in an Excel…

We used PivotTables to calculate, analyze and summarize data. This allows us to see trends, patterns, and comparisons in our data. Sometimes we…

Sometimes we may want to check for the format of a cell in Excel VBA. This tutorial shows you how to get the…

In this section, we will cover how to calculate the production per hour in Excel. The production per hour is a measure that…

A percentile graph helps us to visualize how a given value ranks against all the available data. It looks at all the data…

Sometimes you get a dataset that has numbers stored as text. This means you cannot work with the values as you would with…

Finding cells that meet multiple criteria is a common task in Excel. In this tutorial, we look at how to use the combination…