What is the difference between Max() and Large()???

[LMF]

What is the difference between Max() and Large()???

I know in Large u can do first largest, second largest and so on, but Max u can't..

is this the answer i am looking for???

 

[daleyman]

Basically, yeah, i guess.

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.

 

[Aladin Akyurek]

On 2002-04-13 14:32, LMF wrote:
What is the difference between Max() and Large()???

I know in Large u can do first largest, second largest and so on, but Max u can't..

is this the answer i am looking for???

MAX(Range)==LARGE(Range,1)

where == means identical, so the answer is yes.