Question: what is the difference between max and large in excel?
Answer: MAX returns the 1st highest of a series, whereas with Large you can specify what position you want, for example of a set of 100 values you can select the 2nd, 3rd, 4th or even 56th highest value of the series, when ranked in order.