Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database In Depth Relational Theory For Practitioners

Authors: C.J. Date

1st Edition

0596100124, 978-0596100124

More Books

Students also viewed these Databases questions