Try with CSE
=LARGE(SUMPRODUCT(--(NOT(ISERROR(E5:X5)))*IFERROR(E5:$X$5,0)),1)
Rajann.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of anil kumar
Sent: Jan/Tue/2012 05:02
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ reqment of
Thanks sir,
I will follow this formula than i give u msg
Thanks again
Anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Dear Anil,
In large function 1 is using for rank
See details about large function..
MS Excel: Large Function
--
In Excel, the *Large* function returns the nth largest value from a set of
values.
The syntax for the *Large* function is:
Large( array, nth_position )
sorry sir,
but i want to know what is use of 1 in large formula.
and my second queary can solve
anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
Dear Anil,
You can use..simple
=MAX(D2:G2)
or
=LARGE(D2:G2,1)
See attached sheet..
On Tue, Jan 31, 2012 at 4:24 PM, anil kumar wrote:
> Hello sir,
>
> Thanks for response, I attach file.
>
>
> anil
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate t
Hello sir,
Thanks for response, I attach file.
anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may
Dear Anil,
Please explain, we are not getting your point,
On Tue, Jan 31, 2012 at 4:05 PM, anil kumar wrote:
> Hello friends,
>
> I want to a formula of gareter than. any body tell me.
>
>
> Anil
>
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accura
