Hi Group,
Attached is a sample excel tracker in which the leaves taken by every
employee is entered in a single sheet (Data).
Now this is data has to split-ted in to respective months with the count
type .
Some Sample data is entered for the month of April12 for easy reference.
--
Regards
Sant
Hello Anyone ,
Please can you send / share leave tracker file you have for your
organisation...as I am looking for my team which consits of around 250
employees.
Regards,
Nayan K Lodaya | IBOD Inter Entity Swaps | J.P. Morgan | 9th Floor , A-wing,
Prism Towers, Malad(W), Mumbai | T: GDP : 308
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
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
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
>
>
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
, 2012 2:35 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Leave tracker
Hi Group,
Attached is a sample excel tracker in which the leaves taken by every employee
is entered in a single sheet (Data).
Now this is data has to split-ted in to respective months with the count type
, 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
*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
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
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 total leaves taken in that month with dates
of "IL & "NCNS" Staus from Sheet 1 (details given in attached sheet)
In sheet3 i hav
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
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
13 matches
Mail list logo