Forum Discussion
Anonymous
Aug 16, 2018nth 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
Anonymous
Aug 16, 2018I guess that wont work .
If we change , lets say.. cell 'A3' to 7.5, it should give ans '7.5' but it still shows '5'
If we change , lets say.. cell 'A3' to 7.5, it should give ans '7.5' but it still shows '5'
Lorenzo Kim
Aug 16, 2018Bronze Contributor
it's nice to learn... then Mr. Lewin's solution is the best!
thanks
thanks