Using Count and Offset Functions in Excel for Data Analysis, for example, to find the latest sales data
In the last training video we learnt how to create dynamic ranges using the offset and counta functions.
Sometimes, however, we may need to find specific information quickly from a large Excel worksheet and we may not have the patience and time to scroll through thousands of rows and columns of data. In our example we have extracted the latest sales data from the dates and the corresponding sales.
Watch the Excel training video below to see how the process of finding the latest data is implemented step by step:
How to find the latest (or earliest) date and a corresponding value