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
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.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use
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
egroups.com
Subject: Re: $$Excel-Macros$$ Rank Formula
Dear Guillett Sir
That amazing formula,I never thought sum product formula useable
Thanks very very much
If you have time one another problem I faced ,This is confusing formula
bcos more than three criteria for passing C
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: $$
:41 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Rank Formula
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Plea
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
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ 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 n
Software
> dguille...@gmail.com
> -Original Message- From: Secret Shot
> Sent: Sunday, March 18, 2012 4:02 PM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Rank Formula required
>
> Dear Expert,
>
> I want any formula to find Rank in Excel but that ra
@googlegroups.com
Subject: $$Excel-Macros$$ Rank Formula required
Dear Expert,
I want any formula to find Rank in Excel but that rank should be
Unique.. if the value are same for ranking its should check second
pereority. attach is the file for understanding the problme.
Kindly help pls. i hav
cel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Rank Formula required
Dear Expert,
I want any formula to find Rank in Excel but that rank should be
Unique.. if the value are same for ranking its should check second
pereority. attach is the file for understanding the problme.
Kindly help pls
Dear Expert,
I want any formula to find Rank in Excel but that rank should be
Unique.. if the value are same for ranking its should check second
pereority. attach is the file for understanding the problme.
Kindly help pls. i have tried with rank formula but it dosent work.
--
Pankaj Pandey
Bhopa
20 matches
Mail list logo
