Large Function, multiple columns

[Wonga Denga]

I would like to extract the 2nd, 3rd, 4th etc values of a sheet using the LARGE FUNCTION from different columns.

So I want excel to examine columns (H4-H57) + (M4-M47) + (R4-R47) + (W4-W47) and give me the highest value. In another cell I would like the 2nd highest value. In the next I would like the 3rd highest. I tried using the LARGE FUNCTION but it I came with an error. Does anyone know how to approach this using the LARGE FUNCTION? Thanks.

 

[Fluff]

Hi & welcome to MrExcel.
How about
=AGGREGATE(14,6,H4:W47/(MOD(COLUMN(H4:W4),5)=3),1)

 

[AhoyNC]

Another option would be to use named range.
Under Formulas select Define Names.
-Enter a Range Name (I just used TestR in this example)
-Under refers to: select the columns. Select column H4:H47 then holding down the CTRL key select M4:M47 ... etc.

Then just use the LARGE function referring to the TestR (or the name you used).

Book1
	F	G	H	I				M	N				R	S				W
4	1	500	227					278					158					39
5	2	492	455					32					364					15
6	3	490	208					219					234					127
7			490					82					419					500
8			175					428					122					262
9			272					75					369					68
10			379					195					148					378
11			46					63					250					252
12			33					292					355					228
13			492					169					463					149
Sheet1

Cell Formulas
Range	Formula
G4	G4	=LARGE(TestR,1)
G5	G5	=LARGE(TestR,2)
G6	G6	=LARGE(TestR,3)