=large function for non-contiguous cells

[kschmittel]

Entering arrays into functions.

I've been trying to use =large(), which will accept an array as its first argument. I can get this to work with a contiguous array, but I can't figure out how to enter a set of non-contiguous cells.

It seems like it should accept this, but I don't seem to be able to input it properly.

 

[barry houdini]

Hello kschmittel, welcome to MrExcel,

Which cells do you want to include exactly, is there a pattern like every 3rd or 4th cell, or something like that?

 

[Aladin Akyurek]

Entering arrays into functions.

I've been trying to use =large(), which will accept an array as its first argument. I can get this to work with a contiguous array, but I can't figure out how to enter a set of non-contiguous cells.

It seems like it should accept this, but I don't seem to be able to input it properly.

A set up as follows will work:

=LARGE( (A2,B6,C7), 2)