Hi Chief
i am not sure i fully understand your requirements, if you could explain
better and show your expected answers FULLY in a new column at least that
might give some perspective or trend for us to follow.
for instance if you say Formula should eliminate who are ranking from 1
to 10, which
>
> Hi Dhananjay,
>
>
Please Find the Attachment.
> Regards,
>
>
Excel Beginner
>
>
> I need a solution as per my query in attached file.
>>
>> Pl. revert in case of any clarification or any confusion.
>>
>> Regards,
>> Dhananjay
>>
>> --
>> Join official
Hi Dhananjay,
Please find the attachment.
Regards,
Excel Beginner
On Mon, Sep 10, 2012 at 12:32 AM, Dhananjay Pinjan wrote:
> Dear Experts,
>
> I need a solution as per my query in attached file.
>
> Pl. revert in case of any clarification or any confusion.
>
> Regards,
> D
Hi Mr. David / Excel Experts,
I am very impressed the way you have given answer. I was expecting the
use of formula "RANK' or 'SUMPRODUCT'. But you have just given it with
very simple equtions. Hat's off.
Sorry to say, but I have some modifications in my requirements (pl.
refer attached Excel Fil
Wow!!! Thanks.
On Mon, Sep 10, 2012 at 1:09 AM, David Grugeon wrote:
> See attached
>
> On 10 September 2012 05:02, Dhananjay Pinjan wrote:
> > Dear Experts,
> >
> > I need a solution as per my query in attached file.
> >
> > Pl. revert in case of any clarification or any confusion.
> >
> > Reg
See attached
On 10 September 2012 05:02, Dhananjay Pinjan wrote:
> Dear Experts,
>
> I need a solution as per my query in attached file.
>
> Pl. revert in case of any clarification or any confusion.
>
> Regards,
> Dhananjay
>
> --
> Join official facebook page of this forum @
> https://www.faceb
t;
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *amar takale
> *Sent:* 06 September 2012 10:26
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Rank Formula
&
Subject: Re: $$Excel-Macros$$ Rank Formula
Rajan I think this is not working,I used it but wrong output in passing
formula sheet.Guillett Sir formula VBA for passing is fanstatic
On Wed, Sep 5, 2012 at 8:32 PM, Rajan_Verma
wrote:
=IF(ISERROR(MATCH(0,N(F11:L11>$F$10:$L$10),0)),"Passe
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *amar takale
> *Sent:* 05 September 2012 1:03
>
> *To:* excel-macros@google
hore <mailto:kishore...@gmail.com>
Sent: Tuesday, September 04, 2012 7:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rank Formula
hai..friends/Masters,
i had applied formula in column G2 and i need same numer in H3
but while copying it shows only ref.
Plea
Tuesday, September 04, 2012 7:15 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Rank Formula
>
> hai..friends/Masters,
>
> i had applied formula in column G2 and i need same numer in H3
>
> but while copying it shows only ref.
>
> Please t
Put in H5 and copy down
=SUMPRODUCT(--($F$5:$F$14<>"fail"),--(D5<$D$5:$D$14))+1
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: kumar Kishore
Sent: Tuesday, September 04, 2012 7:15 AM
To: excel-macros@googlegroups.com
Subject: Re: $$
One way using this array formula (entered using ctrl+shift+enter CSE)
INDEX($C:$C,MATCH(LARGE(IF($F$5:$F$15<>"fail",$D$5:$D$15),ROW(A1)),$D:$D,0))
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Tuesday, September 04, 2012 6:41 AM
To: excel-m
hai..friends/Masters,
i had applied formula in column G2 and i need same numer in H3
but while copying it shows only ref.
Please tell how to do.
Regards,
Kishore
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already
Hi Pankaj
PFA,
Try :
=RANK(E2,E$2:E$9)+SUMPRODUCT(--(E$2:E$9=E2),--(A2 wrote:
> Shorter. Also enter using CSE (ctrl+shift+enter)
>
> =COUNTIF($F$2:$F$9,">"&F2)+**SUM(IF(F2=$F$2:F2,1,0))
>
>
>
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
> -Original Messag
Shorter. Also enter using CSE (ctrl+shift+enter)
=COUNTIF($F$2:$F$9,">"&F2)+SUM(IF(F2=$F$2:F2,1,0))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Secret Shot
Sent: Sunday, March 18, 2012 4:02 PM
To: excel-macros@googlegroups.com
Subj
See attached
=SUM(1*(F2<$F$2:$F$9))+1+IF(ROW(F2)-ROW($F$2)=0,0,SUM(1*(F2=OFFSET($F$2,0,0,INDEX(ROW(F2)-ROW($F$2)+1,1)-1,1
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Secret Shot
Sent: Sunday, March 18, 2012 4:02 PM
To: excel-mac
17 matches
Mail list logo
