Large for disjunct cells

A

Arne Hegefors

Hi! I ´want to use the worksheet function LARGE for three different cells.
however the cells are not placed next to each other (and i cannot change
that) and that gives me alot of trouble. is there any way to solve that?
thanks!
 
N

Niek Otten

=LARGE((A1,C1,F1,C11,F9),2)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi! I ´want to use the worksheet function LARGE for three different cells.
| however the cells are not placed next to each other (and i cannot change
| that) and that gives me alot of trouble. is there any way to solve that?
| thanks!
 
Top