Originally Posted by Spencer101

Try putting the non-contiguous range in a separate set of brackets.
So your example formula becomes =LARGE((E3:E16,G3:G13),2)