More info – Excel Function LARGE

Please refer my previous post – about Large Function

With referance to comment by Robert…

Both these functions Large and Small, presumably sorting the values in range given internally and then returning the results as per rank. Yes if your computer memory is really small then there might be some issue when you are using large function and the range items are numerous.

But you can do a smart thing as pointed out by Robert use Max / Min function if you want to find largest or smallest value respectively it works faster. Use Large/Small only when you want to find 2nd or third value in series.

Thanks Robert for your comment.