Microsoft Excel training videos

Finding latest sales data in Excel

Use the combination of offset and count functions

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:

Further Reading

Finding latest sales data in Excel