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:
|