copy pasting would not work as the cell referencing takes place... u will need to edit the code according to the column and the row used.
Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 22, 2009 at 8:09 PM, Saurabh <saurabh.pa...@aegisbpo.net> wrote: > Exactly want the same.. Thanks.. > > One more query... > > 1). I m not able to use the same formula if i copy and paste the same. > 2). What if if want (Count of "P") + (Count of "HD"/2) devide by total > count Team Wise? > > Sorry for inconvience. > > Thanks, > Saurabh Patel > > ------------------------------ > *From:* vivek agrawal [mailto:vivek.agrawa...@gmail.com] > *Sent:* Wednesday, July 22, 2009 7:55 PM > > *To:* Saurabh > *Subject:* Re: $$Excel-Macros$$ Re: Count of Status > > guess this is what you want > > Thanks and Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com - Saving energy-Save Earth > > > > > On Wed, Jul 22, 2009 at 6:18 PM, Saurabh <saurabh.pa...@aegisbpo.net>wrote: > >> i mean it should get divied and get the result. >> >> 4/4 = 100% >> >> Thanks, >> Saurabh Patel >> >> >> ------------------------------ >> *From:* vivek agrawal [mailto:vivek.agrawa...@gmail.com] >> *Sent:* Wednesday, July 22, 2009 6:07 PM >> *To:* Saurabh >> *Subject:* Re: $$Excel-Macros$$ Re: Count of Status >> >> hi saurabh >> you have mentioned.... "Count of P in Team 1 / non blank count of Team 1" >> >> this is exactly what i have done.... >> >> if you want some other output, then please enter the desired output >> manually in the respective cells in the sheet so that i understand the >> desired result. >> >> Thanks and Regards, >> Vivek Agrawal >> Skype ID - vivek.agrawal83 >> >> GoogleMoonlight.com - Saving energy-Save Earth >> >> >> >> >> On Wed, Jul 22, 2009 at 6:03 PM, Saurabh <saurabh.pa...@aegisbpo.net>wrote: >> >>> Thanks Vivek, >>> >>> Just need more help. >>> Result wanted was count of P divided with count all. >>> >>> Thanks, >>> Saurabh Patel >>> ------------------------------ >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-mac...@googlegroups.com] *On Behalf Of *vivek agrawal >>> *Sent:* Wednesday, July 22, 2009 5:03 PM >>> *To:* excel-macros@googlegroups.com >>> *Subject:* $$Excel-Macros$$ Re: Count of Status >>> >>> Hello Saurabh >>> Attached is the file with the proposed solution. Hope it helps >>> >>> ALL THE BEST >>> >>> Regards, >>> Vivek Agrawal >>> Skype ID - vivek.agrawal83 >>> >>> GoogleMoonlight.com - Saving energy-Save Earth >>> >>> >>> >>> >>> On Wed, Jul 22, 2009 at 4:19 PM, Saurabh <saurabh.pa...@aegisbpo.net>wrote: >>> >>>> Hi All, >>>> >>>> I m having a trouble in attached file. Want to have a Team Wise Count of >>>> Status. Attaching the file for the reference. >>>> >>>> *Thanks,* >>>> *Saurabh Patel* >>>> >>>> DISCLAIMER:The information contained in this electronic message and in >>>> any attachments to this message is >>>> confidential, legally privileged and intended only for the >>>> person or entity to which this electronic >>>> message is addressed. If you are not the intended recipient, >>>> please notify the system manager and >>>> you are hereby notified that any distribution, copying, review, >>>> retransmission, dissemination or >>>> other use of this electronic transmission or the information >>>> contained in it is strictly prohibited. >>>> Please accordingly also note that any views or opinions >>>> presented in this email are solely those of >>>> the author and may not represent those of the Company or bind >>>> the Company. This message has been >>>> scanned for viruses and dangerous content by Mail Scanner, and >>>> is believed to be clean. >>>> The Company accepts no liability for any damage caused by any >>>> virus transmitted by this email. >>>> >>>> >>>> >>>> >>> >>> >>> >>> DISCLAIMER:The information contained in this electronic message and in >>> any attachments to this message is >>> confidential, legally privileged and intended only for the >>> person or entity to which this electronic >>> message is addressed. If you are not the intended recipient, >>> please notify the system manager and >>> you are hereby notified that any distribution, copying, review, >>> retransmission, dissemination or >>> other use of this electronic transmission or the information >>> contained in it is strictly prohibited. >>> Please accordingly also note that any views or opinions >>> presented in this email are solely those of >>> the author and may not represent those of the Company or bind >>> the Company. This message has been >>> scanned for viruses and dangerous content by Mail Scanner, and >>> is believed to be clean. >>> The Company accepts no liability for any damage caused by any >>> virus transmitted by this email. >>> >>> >>> >> DISCLAIMER:The information contained in this electronic message and in any >> attachments to this message is >> confidential, legally privileged and intended only for the person >> or entity to which this electronic >> message is addressed. If you are not the intended recipient, >> please notify the system manager and >> you are hereby notified that any distribution, copying, review, >> retransmission, dissemination or >> other use of this electronic transmission or the information >> contained in it is strictly prohibited. >> Please accordingly also note that any views or opinions presented >> in this email are solely those of >> the author and may not represent those of the Company or bind the >> Company. This message has been >> scanned for viruses and dangerous content by Mail Scanner, and is >> believed to be clean. >> The Company accepts no liability for any damage caused by any >> virus transmitted by this email. >> >> >> > > DISCLAIMER:The information contained in this electronic message and in any > attachments to this message is > confidential, legally privileged and intended only for the person > or entity to which this electronic > message is addressed. If you are not the intended recipient, > please notify the system manager and > you are hereby notified that any distribution, copying, review, > retransmission, dissemination or > other use of this electronic transmission or the information > contained in it is strictly prohibited. > Please accordingly also note that any views or opinions presented > in this email are solely those of > the author and may not represent those of the Company or bind the > Company. This message has been > scanned for viruses and dangerous content by Mail Scanner, and is > believed to be clean. > The Company accepts no liability for any damage caused by any > virus transmitted by this email. > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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,000 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 -~----------~----~----~----~------~----~------~--~---