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