The Excel Function of the month is
LARGE
Returns the k-th largest value in a data set.
We know that MAX returns the highest number. But what if we want the second highest, or third or fourth highest? That’s where LARGE is very useful. Large only needs two things :
An array (data set) and what level of number you’re looking for. So, for example, to find the first, second and third highest numbers in an array, see this pic:
I have created posters that you can stick up in your class. There are 33 posters. Below is an index of what functions are available and a sample sheet (to the right) showing what the posters look like. You can purchase them from the Tech Teachers online shop.
Functions covered
AND, AVERAGE, CONCATENATE, COUNT, COUNTA, COUNTBLANK, COUNTIF, DATE, FIND, INT, LARGE, LEFT, LEN, LOWER, MAX, MEDIAN, MID, MIN, MODE, NOW, OR, POWER, RAND, RANDBETWEEN, RIGHT, ROUND, SMALL, SUM, SUMIF, TIME, TODAY, UPPER, VLOOKUP
Find out more about the posters here
Be the first to comment