Quote:
Originally Posted by P-man
I will not let me complete a formula with too many arguments, hence I have used : to separate the data inputs in this formula.
|
Try putting the non-contiguous range in a separate set of brackets.
So your example formula becomes =LARGE((E3:E16,G3:G13),2)