Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2016-03-02 Thread mohd sadiq
Dear Pankaj , Sorry for delayed response . Yet its not working. Please refer the attached mail for your reference. On Wed, Jan 13, 2016 at 7:06 PM, Pankaj Sharma wrote: > check this out !!! > > > > *PJ

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2016-01-13 Thread Pankaj Sharma
check this out !!! *PJ * *MIS Analyst* *Greater Kailash-1, New Delhi.* *Instagram* *pj_sharma_* *Tweeter* *dude_sharma_pj**Facebook** www.facebook.com/dude.pj * *We meet for a reason,

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2016-01-13 Thread mohd sadiq
Team , Please help to closed it on priority On Fri, Jan 8, 2016 at 2:03 PM, mohd sadiq wrote: > Opsss , sorry > > PFA the same. > > On Thu, Jan 7, 2016 at 7:16 PM, Pankaj Sharma > wrote: > >> where is the attachment. ??? >> >> >> >> *Pankaj

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2016-01-06 Thread mohd sadiq
Dera Team , Please help on the same On Mon, Jan 4, 2016 at 4:34 PM, mohd sadiq wrote: > Hello Pankaj , > > Pls help on the same > > On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq > wrote: > >> Hello , >> >> I need put Week OFF (WO) basis of

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2016-01-06 Thread Pankaj Sharma
it's already done i think.. pfa *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Wed, Jan 6, 2016 at 6:15

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2016-01-04 Thread mohd sadiq
Hello Pankaj , Pls help on the same On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq wrote: > Hello , > > I need put Week OFF (WO) basis of attached excel (Day wise WO count) > (Excel attached with your reference.( if change day wise Week OFF count > then it should be

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2015-12-23 Thread Pawan Yadav
You can also use this formula : *=COUNTIF(D3:D22,"WO") *in Monday column and drag to right. On Thursday, 10 December 2015 19:01:37 UTC+5:30, Sadiq wrote: > > Hello , > > I need put Week OFF (WO) basis of attached excel (Day wise WO count) > (Excel attached with your reference.( if change day

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2015-12-15 Thread Pankaj Sharma
Formula updated in example sheet *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 15, 2015 at

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2015-12-15 Thread Pankaj Sharma
done! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Tue, Dec 15, 2015 at 7:51 PM, mohd sadiq

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2015-12-15 Thread mohd sadiq
Dear All , Pls help on the same. On Dec 14, 2015 3:00 PM, "mohd sadiq" wrote: > yet I am not getting solution :( > > > Rgds, Mohd Sadiq > > > On Fri, Dec 11, 2015 at 12:06 PM, mohd sadiq > wrote: > >> Dear Team , >> >> Please help on the same as

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2015-12-14 Thread mohd sadiq
yet I am not getting solution :( Rgds, Mohd Sadiq On Fri, Dec 11, 2015 at 12:06 PM, mohd sadiq wrote: > Dear Team , > > Please help on the same as i need to make it on on priority. > > > Thanx > > > On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2015-12-11 Thread Pankaj Sharma
check it! *Pankaj Sharma * *MIS Analyst* *Greater Kailash-1, New Delhi* *Email * *p ankaj123...@gmail.com * *Skype** pankaj.sharma_pj* On Fri, Dec 11, 2015 at 12:06 PM, mohd sadiq

$$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2015-12-10 Thread mohd sadiq
Hello , I need put Week OFF (WO) basis of attached excel (Day wise WO count) (Excel attached with your reference.( if change day wise Week OFF count then it should be automatically changed in Roster sheet. Example- We have 20 agents in a Shift and we need to give Weekly OFF to everyone basis of

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

2015-12-10 Thread mohd sadiq
Dear Team , Please help on the same as i need to make it on on priority. Thanx On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq wrote: > Hello , > > I need put Week OFF (WO) basis of attached excel (Day wise WO count) > (Excel attached with your reference.( if change day