Finding latest sales data in Excel

Use the combination of offset and count functions

Finding latest sales data in Excel worksheet: In this age of 'instant' recipes and everything 'instant', you may need to get the latest sales data or the latest scores for quick decisions. In the example we have input the dates and the corresponding sales. Now we wish to find the latest sales figure. The Excel training video below describes how this can be done quickly using the offset and count functions.