Fwd: Fwd: $$Excel-Macros$$ instead of formula need macros

2012 6:08 AM > *To:* excel-macros@googlegroups.com > *Subject:* Fwd: $$Excel-Macros$$ instead of formula need macros > > > Hi All, > > > > Thanks for resolving this query and I will appreciate your valuable > concern. > > > > Request you to ple

Re: $$Excel-Macros$$ instead of formula need macros

No helper =SUMPRODUCT((WEEKDAY($G$2:$G$17)>1)*(WEEKDAY($G$2:$G$17)<7)*($H$2:$H$17=B3)) Don Guillett SalesAid Software dguille...@gmail.com From: Lokesh Loki Sent: Friday, February 24, 2012 9:15 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ instead of formula need

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Please see attached sheet as per ur requirement. Thanks & regards, Noorain Ansari ** *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Fri, Feb 24, 2012 at 8:45 PM, Lokesh Loki wrote: >

Re: $$Excel-Macros$$ instead of formula need macros

Hi Noorain, In the excel file i have re corrected the dates, like this i want working days for the mentioned name in macros. please see the excel file attached. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Please see attached sheet with solution. >

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Please use it without using Helping Column. =SUMPRODUCT(--($H$2:$H$51=B3)*(TEXT($G$2:$G$51,"ddd")<>"Sat")*(TEXT($G$2:$G$51,"ddd")<>"Sun")) On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Please see attached sheet with solution. > > Hope it help to you. > >

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Please see attached sheet with solution. Hope it help to you. On Fri, Feb 24, 2012 at 8:12 PM, Lokesh Loki wrote: > Hi Noorain, > > Please find the attached sample excel file for your reference. > > Regards > Lokesh.M > > > On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI > wrote:

Re: $$Excel-Macros$$ instead of formula need macros

le...@gmail.com > > *From:* lokesh > *Sent:* Friday, February 24, 2012 7:20 AM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ instead of formula need macros > > > Hi All, > > > > I am using this formula to extract the working days i

Re: $$Excel-Macros$$ instead of formula need macros

send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.com From: lokesh Sent: Friday, February 24, 2012 7:20 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ instead of formula need macros Hi All, I am using this formula to extract the

Re: $$Excel-Macros$$ instead of formula need macros

Hi Noorain, Please find the attached sample excel file for your reference. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Can you share a sample sheet..What is your adject requirement. > > On Fri, Feb 24, 2012 at 6:50 PM, lokesh wrote: > >> Hi All,*

Re: $$Excel-Macros$$ instead of formula need macros

Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh wrote: > Hi All, > > ** ** > > I am using this formula to extract the working days in a month, but this > formula is very big and while pulling the report it takes too much t

$$Excel-Macros$$ instead of formula need macros

Hi All, I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. So I need a macros instead of this formula. Could you please solve this query to me. Formula is = Selection.Fo