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,
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
Hi Dhananjay,
Please find the attachment.
Regards,
Excel Beginner
On Mon, Sep 10, 2012 at 12:32 AM, Dhananjay Pinjan dppin...@gmail.comwrote:
Dear Experts,
I need a solution as per my query in attached file.
Pl. revert in case of any clarification or any confusion.
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 facebook page of this
Wow!!! Thanks.
On Mon, Sep 10, 2012 at 1:09 AM, David Grugeon da...@grugeon.com.au wrote:
See attached
On 10 September 2012 05:02, Dhananjay Pinjan dppin...@gmail.com wrote:
Dear Experts,
I need a solution as per my query in attached file.
Pl. revert in case of any clarification or
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)
See attached
On 10 September 2012 05:02, Dhananjay Pinjan dppin...@gmail.com 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 @
]*
* *
*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
** **
Rajan I think this is not working,I used
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 rajanverma1...@gmail.com
wrote:
=IF(ISERROR(MATCH(0,N(F11:L11$F$10:$L$10
: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 tell how to do.
Regards,
Kishore
--
Join official facebook
: $$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 Can you help me?
Pls Pls .
Appreciate
*
*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@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Rank Formula
** **
Dear
--
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
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
-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 Please Help,
Urgent
Put in H5 and copy down
=SUMPRODUCT(--($F$5:$F$14fail),--(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: $$Excel-Macros$$ Rank Formula
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
Subject: $$Excel-Macros$$ Rank Formula required
Dear Expert,
I want any formula to find Rank in Excel but that rank should
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
-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. i
: $$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 have tried with rank formula
20 matches
Mail list logo