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

LMF · Apr 13th, 2002, 03:32 PM

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 · Apr 13th, 2002, 03:39 PM

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 · Apr 13th, 2002, 04:06 PM

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 13th, 2002, 03:32 PM	#1
LMF Board Regular Join Date: Mar 2002 Posts: 73	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???

Apr 13th, 2002, 03:39 PM	#2
daleyman Board Regular Join Date: Mar 2002 Location: London, UK Posts: 167	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.