$$Excel-Macros$$ Re: Need help on formula

Hi All, Thanks for all your support. Regards, Vinod On Thu, Aug 27, 2009 at 11:13 PM, vivek agrawal wrote: > Hi > As per what you want... my answers are in red with yellow background > > The best way for what you want is that sort the column and then apply the > formula in red with yellow...

$$Excel-Macros$$ Re: Need help on formula

Hi As per what you want... my answers are in red with yellow background The best way for what you want is that sort the column and then apply the formula in red with yellow... Hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-S

$$Excel-Macros$$ Re: Need help on formula

Hi Vinod, Did you find my solution or not? This is my seventh mail. Regards Sandeep On Wed, Aug 26, 2009 at 9:50 AM, Prashant Bhawar wrote: > > > On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wrote: > >> Hello Team, >> >> How do i rank only positive numbers. Plz help me on formula. >> >> Example

$$Excel-Macros$$ Re: Need help on formula

hi i got the solution with out extra column hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 4:37 PM, vinod rao wrote: > This will help.Thank you > > can you put formula without using Fcolu

$$Excel-Macros$$ Re: Need help on formula

Hi Vinod, If you need then see this too. It is with both with and without NA error. Regards Sandeep - Original Message - From: vinod rao To: excel-macros@googlegroups.com Sent: Wednesday, August 26, 2009 3:53 PM Subject: $$Excel-Macros$$ Re: Need help on formula Plz help

$$Excel-Macros$$ Re: Need help on formula

rows 1157, 1158, 1159 and 1160 also contain positive values. 0.34 so these would be considered 1 like wise 1162 to 1156 also contain 0.6 which are again positive hence count to ranks 5-10.. i hope you understand what i want to convey Thanks and Regards, Vivek Agrawal Skype ID - vi

Fw: $$Excel-Macros$$ Re: Need help on formula

Hi Vinod, Find the attached solution. If it not fullfill your request then let me know. Regards Sandeep - Original Message - From: vinod rao To: excel-macros@googlegroups.com Sent: Wednesday, August 26, 2009 3:53 PM Subject: $$Excel-Macros$$ Re: Need help on formula Plz

$$Excel-Macros$$ Re: Need help on formula

Hi Vinod, Find the attached solution. If it not fullfill your request then let me know. Regards Sandeep - Original Message - From: vinod rao To: excel-macros@googlegroups.com Sent: Wednesday, August 26, 2009 3:53 PM Subject: $$Excel-Macros$$ Re: Need help on formula Plz

$$Excel-Macros$$ Re: Need help on formula

how come it becomes difficult to add a column and then hide that. this will not change the visual alsoas the column would be hidden i feel it would be difficult to get without using F... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy

$$Excel-Macros$$ Re: Need help on formula

-Macros$$ Re: Need help on formula Plz help! I am looking as mentioned in column G Plz see attached file. On Wed, Aug 26, 2009 at 3:47 PM, vinod rao wrote: Hello Vivek, I could not get the right answer. I need like Example Amount Rank 200 3 100 2

$$Excel-Macros$$ Re: Need help on formula

This will help.Thank you can you put formula without using Fcolumn, I want to findout the data from E only because my workshee is restricted to add one more line.? any suggestion on this plz. On Wed, Aug 26, 2009 at 4:07 PM, vivek agrawal wrote: > Hope This Helps > > > Thanks and Regards, > Vivek

$$Excel-Macros$$ Re: Need help on formula

Hope This Helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 3:47 PM, vinod rao wrote: > Hello Vivek, > > I could not get the right answer. I need like > > Example > > Amount Rank > 200

$$Excel-Macros$$ Re: Need help on formula

Plz help! I am looking as mentioned in column G Plz see attached file. On Wed, Aug 26, 2009 at 3:47 PM, vinod rao wrote: > Hello Vivek, > > I could not get the right answer. I need like > > Example > > Amount Rank > 200 3 > 100 2 > -50NA > 10

$$Excel-Macros$$ Re: Need help on formula

Hello Vivek, I could not get the right answer. I need like Example Amount Rank 200 3 100 2 -50NA 10 1 -5 NA 3004 Can you plz get it done in the new excel file?. Thanks Advance my friend. On Wed, Aug 26, 2009 at 1:09

$$Excel-Macros$$ Re: Need help on formula

The third argument of the RANK function specifies the ranking order Blank or "0" means ascending order any other positive number or "1" means the other way round Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26

$$Excel-Macros$$ Re: Need help on formula

Thank you Very much. Can we have in reverse order, I mean low to high.? Advance thanks to all members. Example Amount Rank 200 4 1002 -50NA 10 1 -5 NA 300 4 On Wed, Aug 26, 2009 at 9:48 AM, vivek agrawal wrote: > Hi > >

$$Excel-Macros$$ Re: Need help on formula

Hi Vinod, Attached file has three different solution scenarios to your query. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 8/25/09, vinod rao wrote: > > Hello Team, > > How do i rank only posit

$$Excel-Macros$$ Re: Need help on formula

On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wrote: > Hello Team, > > How do i rank only positive numbers. Plz help me on formula. > > Example > > Amount Rank > 200 2 > 100 3 > -50NA > 10 4 > -5 NA > 3001 > > > > > i attc

$$Excel-Macros$$ Re: Need help on formula

Hi attached is the solution to your query Hope it helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Tue, Aug 25, 2009 at 9:52 PM, vinod rao wrote: > Hello Team, > > How do i rank only positive numbers. Plz help me on fo