MaX & MiN

How to know the maximum or minimum marks or any other value. If you have a very large data and you want to see which is the maximum or minimum value / marks. Then by using a simple formula we know this .

•  Here is  data of students who scored marks in different subjects . and you can see we have done the sum total of the subjects . 

• Now by applying formula which you can see below in the image =max(range) .Then press enter . you can see which is the highest marks and if you want to know which person has secured highest marks in the HOME tab

  First click on conditional formatting

  Then highlight cell rules

  You can see greater than , more than , between , equal to by which you can see which students secured more or least marks

• Similarly by using formula =min(range). Then press enter . you get the minimum marks of the student.