Which functionv is used to find the highest value in a range of cells?
Answers
Answered by
0
To get the largest or smallest number in a range:
To get the largest or smallest number in a range:
Just enter the formula =Max (A1:F12) or =Min(A1:F12) in a blank cell, and then press Enter key to get the largest or smallest numberin the range, see screenshot:
To get the largest 3 or smallest 3 numbers in a range:
To get the largest or smallest number in a range:
Just enter the formula =Max (A1:F12) or =Min(A1:F12) in a blank cell, and then press Enter key to get the largest or smallest numberin the range, see screenshot:
To get the largest 3 or smallest 3 numbers in a range:
Similar questions