Re: $$Excel-Macros$$ Leave tracker

2012-04-07 Thread Maries
*To:* excel-macros@googlegroups.com > *Subject:* RE: $$Excel-Macros$$ Leave tracker > > Hi Maries, > > Thank you for quick resolution. > > I have a small query I found { } brackets in your formula,can you just > help me in understanding when to use these brackets. > > Regard

Re: $$Excel-Macros$$ Leave tracker

2012-04-07 Thread dguillett1
, 2012 4:15 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Leave tracker Hi Maries, Thank you for quick resolution. I have a small query I found { } brackets in your formula,can you just help me in understanding when to use these brackets. Regards Santosh Kumar Subudhi Hi

Re: $$Excel-Macros$$ Leave tracker

2012-04-07 Thread dguillett1
I would probably design the project differently but Put this is c2 and copy across and down =SUMPRODUCT((Data!$A$2:$A$270=$A2)*(Data!$B$2:$B$270=$B2)*(Data!$C$2:$C$270=C$1)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: santosh subudhi Sent: Saturday, April 07,

RE: $$Excel-Macros$$ Leave tracker

2012-04-07 Thread santosh subudhi
Of *santosh subudhi *Sent:* Apr/Sun/2012 02:02 *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Leave tracker ** ** Hi Rajan, ** ** The pivot option is possible when the team size is very less. I have a very big team and need a formula to fix this. ** ** Is

Re: $$Excel-Macros$$ Leave tracker

2012-04-07 Thread Maries
a option. > > Rajan > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *santosh subudhi > *Sent:* Apr/Sun/2012 02:02 > > *To:* excel-macros@googlegroups.com > *Subject:* RE: $$Excel-Macros$$ Leave tracker > >

RE: $$Excel-Macros$$ Leave tracker

2012-04-07 Thread Rajan_Verma
To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Leave tracker Hi Rajan, The pivot option is possible when the team size is very less. I have a very big team and need a formula to fix this. Is there any way to fix a formula. Regards Santosh Kumar Subudhi From

RE: $$Excel-Macros$$ Leave tracker

2012-04-07 Thread Rajan_Verma
Pivot table can be useful here. See the attached sheet Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of santosh subudhi Sent: Apr/Sun/2012 01:05 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Leave tracker Hi Group, Attache

Re: $$Excel-Macros$$ Leave tracker help required

2011-07-03 Thread maulik desai
HI Vasant Sorry for the late reply & thanks you very much for the effort,. Like to tell you that everything is perfect except one change need to do is that when ever Emp taken leaves continuously like say (15th June to 23rdJune ) so when I click for output it should give me only one entry but

Re: $$Excel-Macros$$ Leave tracker help required

2011-06-26 Thread maulik desai
Hi All, Awaitnig your reply Kindly revert with the solution. On Sun, Jun 19, 2011 at 5:42 PM, maulik desai wrote: > Hi All, > > I am having 1 Excel sheet which contains 3 sheets > In sheet1 main database i have to update in every month for Leave > calculation > In Sheet2 I have to find out the

Re: $$Excel-Macros$$ Leave Tracker

2009-11-12 Thread Deepak Rai
Hi Nayan, Please find the enclosed sample tracker. You can customize as per your need. Regards, Deepak Rai On Thu, Nov 12, 2009 at 7:56 PM, Nayan K Lodaya wrote: > Hello Anyone , > > Please can you send / share leave tracker file you have for your > organisation…as I am looking for my team