answersLogoWhite

0


Best Answer

Use the function MAX to find the largest value. Use the function MIN to find the smallest value. If you want to find the value in a row, use the range of the cells in the row; for column, use the range of cells in the column.

=MAX(A1:A12) will find the largest value in column A (from row 1 through 12).

=MIN(A1:M1) will find the smallest value in row 1 (from column A through M).

User Avatar

Wiki User

13y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you find the largest and smallest number row wise and column wise?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you find rang in math?

the largest number - the smallest number


What does it mean to find the range of the values?

take the largest number in the sample and subtract the smallest number that is the range


How to find the range of numbers?

Subtract the smallest number from the largest number and you will get the distance from the smallest number to the largest number. That is the range. Ex: {-2 -4 -6 3 6 7 12} Smallest number is -6, largest number is 12. 12- (-6) = 12 + 6 = 18. The distance from the smallest number to the largest is 16


Find the difference between the largest and smallest 2-digits number?

The smallest two digit number is 00 (a number used as a wire gauge) and the largest is 99, so the difference between the largest and smallest 2-digits numbers is 99 (99 - 00)


How do you use range in math?

To find the Range in Math you u take the largest number and subtract the smallest number from it. You will then end up with the range of that set of numbers. Example: 2.4.6.5.6.3.3.2.5.9.2 Find the Range Biggest number:9 Smallest number:2 Subtract and you wil end up with the answer Range= 7


How do you find the range of a set of data?

Subtract the smallest number from the largest one.


Can you find the range of two numbers?

Yes you can. You subtract the smallest number from the largest.


What is the medium in math?

Arrange the numbers from smallest to largest and find the middle number.


Find the range what 111 87 75 99 91 -3?

To find the range, you take the smallest number from the largest. In this case, the largest number is 111 and the smallest is -3 111 - (-3) = 114 So the range is 114.


Find the difference between the largest 8 digit number and the smallest 6 digit number?

It is 99,899,999.


How do you find the interval for a set of data?

You find the the smallest and largest values. The interval is the largest minus the smallest.


What is the range of a set data how do you find it?

Range is the biggest number in a set of data subtracted by the smallest number in that set of data.