EAF #23 – Find Max Value in a Dataset Using Criteria – MAX IF Array Formula

Description
Excel Tips for Fitness Trainers and Sports Scientists
Use Excel 2010's built-in functions and features to make your life easier
Find the maximum value of a data set using an IF equation in MAX
Examples of single and multiple criteria are presented
INDEX and MATCH functions discussed

Please take the opportunity to connect and share this video with your friends and family if you find it useful.