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, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Dear Anil,
Please explain, we are not getting your point,
On Tue, Jan 31, 2012 at 4:05 PM, anil kumar kmr7a...@gmail.com 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,
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,
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 kmr7a...@gmail.com wrote:
Hello sir,
Thanks for response, I attach file.
anil
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
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,
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 )
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
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
Please ignore previous
Try this With CSE
=LARGE(--(NOT(ISERROR(E3:W3)))*IFERROR(E3:W3,0),1)
Rajan
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: Jan/Tue/2012 07:07
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ reqment of greater than formula
Try