I have a worksheet that has a number of columns. I need to obtain the first 5 largest values in a particular column. I know I can use LARGE(range, k) to achieve it but it didn't work with large range say B2:B38500.

It should work, is there any merged rows within the range?

There are no merged rows. In fact, I tried it for different ranges. It worked up to B2:B8000 but above this range say B2:B10000, it displayed "#Name" error

I checked it with 100000 rows, works perfectly

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

I have got it, there was a particular cell that contains the error "#Name?" message that prevented the Large function from picking all the values.

Thanks