How to Use Excel to Automatically Create Reports – Part 4: Most Recent Results
uac-books-banner

Learn How to Use Excel to Automatically Create Reports with John Lythe

Part 4: Most Recent Results

Here is the part 4 of this video series. We have been looking at ways that you could extract information from a set of fitness testing data to produce reports simply by selecting a name from a drop-down box. In this video I will show you how to extract only the most recent records for a selected athlete using either the LARGE or the AGGREGATE function to provide the row numbers and INDEX to extract the data.

To learn more, please watch the video below.

Click Here to Download the Example Workbook

mm
I am a former sport scientist, now I just build Excel systems and work with software tools (CRM, Salesforce, PM, Sharepoint) and technology. My day job requires me to sit between the IT department and the sports performance department to make sure that Strength and Conditioning Coaches, Nutritionists, Performance Analysts etc have the hardware and software tools they need to do their jobs. Read More »
free-memeber-button

Home Forums How to Use Excel to Automatically Create Reports – Part 4: Most Recent Results

Tagged: 

This topic contains 0 replies, has 1 voice, and was last updated by mm John Lythe 3 weeks, 2 days ago.

You must be logged in to reply to this topic.

Are you ready? Get it NOW!

Increase more than 700% of Email Subscribers!

Your Information will never be shared with any third party