Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi, I need help with excel. I need to find the highest and lowest score from different soccer matches. For example; match 1 = (2
Hi, I need help with excel. I need to find the highest and lowest score from different soccer matches. For example;
match 1 = (2 - 0)
match 2 = (3 - 1)
match 3 = (0 - 1)
match 4 = (2 - 3)
How can I use index, max, min and match functions to automatic find the highest and lowest scores ? for example, match 4 = highest, match 3 = lowest.
Excel edition 2016
There is basically no inputs in this one. I just want to know how to type in the right functions to get the answer.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started