$$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 vivek.agrawa...@gmail.comwrote: 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 vinod.ma...@gmail.com 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 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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, 2009 at 11:04 AM, vinod rao vinod.ma...@gmail.com wrote: 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 vivek.agrawa...@gmail.comwrote: 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 vinod.ma...@gmail.com 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 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: ROUNDUP
Thanks so much 2009/8/25 jsa-dk johannes.saugbj...@mail.tele.dk ROUNDUP(9235200,23*2;-6)/2000 On Aug 25, 1:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, Hope you are well. I would like to ROUNDUP the figure below 9,235,200.23 € to 9,500 Can you please advise ? Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: ROUNDUP
Hi Jonell, Thanks much appreciated. it works fine. Regards Nour 2009/8/26 jonell jon...@live.com.au On Aug 25, 9:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, Hope you are well. I would like to ROUNDUP the figure below 9,235,200.23 € to 9,500 Can you please advise ? Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 Hi Nourredine, A solution is attached which can use either the RoundUp or RoundDown functions and covers the range from1 to 99.9 million. You can change the formula to use it for numbers less than 1m as demonstrated. Hope this is what you are looking for. Regards, Jonell -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: IF condition formula
Please see the attached file. You'll have to do few adjustments to work it out Joby --- On Tue, 25/8/09, suresh k brave.sur...@gmail.com wrote: From: suresh k brave.sur...@gmail.com Subject: $$Excel-Macros$$ IF condition formula To: Excel group excel-macros@googlegroups.com Date: Tuesday, 25 August, 2009, 5:53 PM Can anyone provide me the formula for below query. Report Date Total Logged Time at Work Hrs 7/2/2009 8.86 7/2/2009 9.03 7/2/2009 7.92 7/2/2009 9.02 7/3/2009 9.05 Answer should be 26.91. Excluding the value less than 8.00 hrs and it should calculate only for one day(7/2/2009). I have tried if condition, and not able to give both the conditions. Love Cricket? Check out live scores, photos, video highlights and more. Click here http://cricket.yahoo.com --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- sol.xls Description: MS-Excel spreadsheet
$$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 PM, vivek agrawal vivek.agrawa...@gmail.comwrote: 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, 2009 at 11:04 AM, vinod rao vinod.ma...@gmail.comwrote: 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 vivek.agrawa...@gmail.com wrote: 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 vinod.ma...@gmail.comwrote: 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 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 vinod.ma...@gmail.com wrote: 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 PM, vivek agrawal vivek.agrawa...@gmail.comwrote: 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, 2009 at 11:04 AM, vinod rao vinod.ma...@gmail.comwrote: 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 vivek.agrawa...@gmail.com wrote: 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 vinod.ma...@gmail.comwrote: 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 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Revised rank positive_vivek agrawal(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: Thanks a lot
Vidyut...Thanks a ton...!! Regarding the excel utilities..-I don't think you need any excel utilities for that.. you just need to change the formula references. One more thing, which you might want to do is to install both the Analysis Tool packs which are available in Tools- AddIns. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Aug 26, 2009 at 3:48 PM, vidyut more vidyutm...@gmail.com wrote: Hi, Thanks again. but i want to know is there any excel utilities should i install. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 vivek.agrawa...@gmail.comwrote: 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 vinod.ma...@gmail.comwrote: 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 PM, vivek agrawal vivek.agrawa...@gmail.com wrote: 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, 2009 at 11:04 AM, vinod rao vinod.ma...@gmail.comwrote: 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 vivek.agrawa...@gmail.com wrote: 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 vinod.ma...@gmail.comwrote: 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 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
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 help! I am looking as mentioned in column G Plz see attached file. On Wed, Aug 26, 2009 at 3:47 PM, vinod rao vinod.ma...@gmail.com wrote: 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 PM, vivek agrawal vivek.agrawa...@gmail.com wrote: 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, 2009 at 11:04 AM, vinod rao vinod.ma...@gmail.com wrote: 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 vivek.agrawa...@gmail.com wrote: 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 vinod.ma...@gmail.com 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 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Rank positive.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$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 - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 5:04 PM, vinod rao vinod.ma...@gmail.com wrote: Hello Vivek, See my file, I am unable to still trace right result. Row 599 has 15.2 value and it should result as 1 but it is showing 34. That is one of the example i am looking for. Regards, Vinod On Wed, Aug 26, 2009 at 4:37 PM, vinod rao vinod.ma...@gmail.com wrote: 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 vivek.agrawa...@gmail.com wrote: 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 vinod.ma...@gmail.comwrote: 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 PM, vivek agrawal vivek.agrawa...@gmail.com wrote: 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, 2009 at 11:04 AM, vinod rao vinod.ma...@gmail.comwrote: 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 vivek.agrawa...@gmail.com wrote: 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 vinod.ma...@gmail.comwrote: 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 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ AWG Calcuator Or Converter Table
Dear All, Can some one snagged for me american wire gauge calculator, table or formula in excel, -- Regards, Mudassar Ramzan --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 vinod.ma...@gmail.com wrote: 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 vivek.agrawa...@gmail.comwrote: 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 vinod.ma...@gmail.comwrote: 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 PM, vivek agrawal vivek.agrawa...@gmail.com wrote: 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, 2009 at 11:04 AM, vinod rao vinod.ma...@gmail.comwrote: 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 vivek.agrawa...@gmail.com wrote: 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 vinod.ma...@gmail.comwrote: 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 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Revised rank positive_vivek agrawal(1).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Re: ROUNDUP
Hi Nourredine BELHAJ Try this formula CEILING(F18,50)/1000 Regards Sivakumar On Aug 25, 4:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, Hope you are well. I would like to ROUNDUP the figure below 9,235,200.23 € to 9,500 Can you please advise ? Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$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 prashant.aca...@gmail.comwrote: On Tue, Aug 25, 2009 at 9:52 PM, vinod rao vinod.ma...@gmail.com 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 attched a solution -- Warm Regard Prashant Bhawar --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Rank positive.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Hidden sheets
I have not been successful in move data from one sheet to another when the destination sheet (sheet3 in this case) has been hidden using the following: Sheets ( “sheet3” ) . Visible = x1VeryHidden When I unhide sheet3 the following Macro works fine. Sub Move_Data() ' ' Move_Data Macro ' Macro recorded 8/26/2009 by Tommy ' ' Keyboard Shortcut: Ctrl+m ' Selection.Copy Sheets(Sheet3).Select Range(A1).Select ActiveSheet.Paste Sheets(Sheet2).Select Application.CutCopyMode = False Range(B1).Select End Sub The error comes up on line 2 having to do with the selection of sheet3 I’m lead to believe that a sheet hidden in this way is not write- protected, thus information transfers in or out can be done. Can someone help me on this? Tomy --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Combine multiple ranges using R1C1
Hello group, after spending hours on the web searching for an answer i resort to you with my noob-question: How do I combine separated ranges of a worksheet like Range(A1:B2, C3:D4).Name = RangeName using R1C1 references as in (pseudocode) Range(Cells(1,1):Cells(2,2), Cells(3,3):Cells(4,4)).Name = RangeName Your knowledge and help is appreciated very much! Cheers, Epi --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: ROUNDUP
Simple and best =CEILING(9235200.23,50)/1000 hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Aug 26, 2009 at 12:50 AM, jsa-dk johannes.saugbj...@mail.tele.dkwrote: ROUNDUP(9235200,23*2;-6)/2000 On Aug 25, 1:39 pm, NOURREDINE BELHAJ nourredine.bel...@gmail.com wrote: Hi All, Hope you are well. I would like to ROUNDUP the figure below 9,235,200.23 € to 9,500 Can you please advise ? Thanks -- Regards Nourredine BELHAJ +41783081988 +33665248617 --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Combine multiple ranges using R1C1
Hi You can use the union function it takes as argument various ranges you want to combine... eg.. Dim MyRange as Range Set MyRange = union(Range(A1),Range(A2), ..) hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Aug 27, 2009 at 6:44 AM, epicenter epi_cen...@hotmail.com wrote: Hello group, after spending hours on the web searching for an answer i resort to you with my noob-question: How do I combine separated ranges of a worksheet like Range(A1:B2, C3:D4).Name = RangeName using R1C1 references as in (pseudocode) Range(Cells(1,1):Cells(2,2), Cells(3,3):Cells(4,4)).Name = RangeName Your knowledge and help is appreciated very much! Cheers, Epi --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Combine multiple ranges using R1C1
Hi Epi, One way is to use the Union thingy Union(Range(Cells(1, 1), Cells(2, 2)), Range(Cells(3, 3), Cells(4, 4))).Name = RangeName Regards - Dave Date: Wed, 26 Aug 2009 18:14:05 -0700 Subject: $$Excel-Macros$$ Combine multiple ranges using R1C1 From: epi_cen...@hotmail.com To: excel-macros@googlegroups.com Hello group, after spending hours on the web searching for an answer i resort to you with my noob-question: How do I combine separated ranges of a worksheet like Range(A1:B2, C3:D4).Name = RangeName using R1C1 references as in (pseudocode) Range(Cells(1,1):Cells(2,2), Cells(3,3):Cells(4,4)).Name = RangeName Your knowledge and help is appreciated very much! Cheers, Epi _ What goes online, stays online Check the daily blob for the latest on what's happening around the web http://windowslive.ninemsn.com.au/blog.aspx --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Hidden sheets
Hi Tomy, I think the problem is that you have the macro 'Selecting' the range which is xlveryhidden. Such a range can't be seleceted, but XL doesn't have to select a cell to work on it. Try the following code lines instead of what you have. Sub Move_Data() ' ' Move_Data Macro ' Macro recorded 8/26/2009 by Tommy ' ' Keyboard Shortcut: Ctrl+m ' Selection.Copy Sheets(Sheet3).Range(A1).PasteSpecial Paste:=xlPasteValues Application.CutCopyMode = False Range(B1).Select End Sub Regards - Dave. Date: Wed, 26 Aug 2009 17:00:03 -0700 Subject: $$Excel-Macros$$ Hidden sheets From: jntwh...@verizon.net To: excel-macros@googlegroups.com I have not been successful in move data from one sheet to another when the destination sheet (sheet3 in this case) has been hidden using the following: Sheets ( “sheet3” ) . Visible = x1VeryHidden When I unhide sheet3 the following Macro works fine. Sub Move_Data() ' ' Move_Data Macro ' Macro recorded 8/26/2009 by Tommy ' ' Keyboard Shortcut: Ctrl+m ' Selection.Copy Sheets(Sheet3).Select Range(A1).Select ActiveSheet.Paste Sheets(Sheet2).Select Application.CutCopyMode = False Range(B1).Select End Sub The error comes up on line 2 having to do with the selection of sheet3 I’m lead to believe that a sheet hidden in this way is not write- protected, thus information transfers in or out can be done. Can someone help me on this? Tomy _ What goes online, stays online Check the daily blob for the latest on what's happening around the web http://windowslive.ninemsn.com.au/blog.aspx --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: excel-macros - 26 new messages in 18 topics - digest
Hi Everybody, I have created a macro in personal macro workbook, and saved it, it worked very good as per my expectation, but now when I run again the macro, it did'nt work the message like Personal Macro workbook should be open. Is there anybody to help me ? REHAN BAIG --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: excel-macros - 26 new messages in 18 topics - digest
for that you need to open the personal workbook in order to run a macro from any workbook... you need to have that workbook open i have windows 7 installed and excel 2007... so the path for personal workbook for me is the below.. C:\Users\Vivek\AppData\Roaming\Microsoft\Excel\XLSTART\ kindly open the personal workbook and then run the macro hope this helps Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Aug 27, 2009 at 9:23 AM, Rehan Baig rehan.bai...@gmail.com wrote: Hi Everybody, I have created a macro in personal macro workbook, and saved it, it worked very good as per my expectation, but now when I run again the macro, it did'nt work the message like Personal Macro workbook should be open. Is there anybody to help me ? REHAN BAIG --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---