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
Mr. Kokitkar
try =MAX(A2:A5)
HTH
if you're looking for the least =MIN(range)