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)
Hello Rajiv
You are looking for LARGE().
=LARGE(Range,n)
OK, I get your point.
Use a helper column with this formula:
=COUNTIFS(A$1:A1,A1)=1
The final result will be:
=AGGREGATE(14,6,1/(B1:B4/A1:A4),2)
another 'crude' way of skinning the 'same' cat..
pardon my peskiness -
hopefully I can move on after this :)
thanks
in case you need VBA for the procedure....
thanks
