Forum Discussion
nth Largest value
Hi Experts, Could you please help me with function for nth Largest value in 'Excel' ? e.g. 2nd largest value is 5 in below mentioned range. Range 2 5 8 8 Regards, Rajiv
Hello Rajiv
You are looking for LARGE().
=LARGE(Range,n)
if I put =Large ( Range,2) this will give ans '8' .
8 appears twice in range whereas 2nd largest value is '5'. Thanks
8 appears twice in range whereas 2nd largest value is '5'. Thanks