Try this for finding 2nd largest value, this works even if you have zeros &
duplicate nos in range, its array formula...
=MAX(IF(A1:A10<>MAX(A1:A10),A1:A10))
Cheers!!
On Fri, Mar 27, 2015 at 12:34 PM, Pramod Singh wrote:
> Hi All.
>
> Good question came from amit.
>
> Excel expert. Can anyone
Hey bro, May i know without any sheet function means What ??
not sheet function and not vba function.
On Friday, March 27, 2015 at 12:35:01 PM UTC+5:30, pramodb35 wrote:
>
> Hi All.
>
> Good question came from amit.
>
> Excel expert. Can anyone get the large second value from the list w
Hi All.
Good question came from amit.
Excel expert. Can anyone get the large second value from the list without
using large function not sheet function and not vba function.
Take the range(a1:a15) and make the logic there.
Pramod
On 27 Mar 2015 11:41, "Mandeep Baluja" wrote:
> did you tried t
did you tried the reply given to you.
On Friday, March 27, 2015 at 11:24:09 AM UTC+5:30, Mandeep Baluja wrote:
>
> you can use large function to do that.
>
> =large(range,2)
>
>
>
>
> On Friday, March 27, 2015 at 11:09:28 AM UTC+5:30, Amit Desai (MERU) wrote:
>>
>> Dear Friends,
>>
>>
>>
>> P
Dear Mandeep,
Oh wow…Thanks a lot.. It worked as needed.
Best Regards,
Amit
From: Mandeep Baluja [mailto:rockerna...@gmail.com]
Sent: Friday, March 27, 2015 11:24 AM
To: excel-macros@googlegroups.com
Cc: Amit Desai (MERU)
Subject: Re: Find Second Highest value from data
you can use large funct
you can use large function to do that.
=large(range,2)
On Friday, March 27, 2015 at 11:09:28 AM UTC+5:30, Amit Desai (MERU) wrote:
>
> Dear Friends,
>
>
>
> Please let me know if I want to find second highest value from a data
> range how shall I do that?
>
>
>
>
>
> Please let me kn
