How to find out the data in six month record

Solved/Closed
subodh - Nov 8, 2014 at 06:39 AM
 subodh - Nov 15, 2014 at 03:00 AM
Hello,

I have six month excel attendance sheet. which formula can i use to know in which month which of the employee has left and who has joined?


Related:

2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Nov 8, 2014 at 07:09 AM
subodh, Good morning.

You can use a lot of differents methods to obtain this kind of information using Excel.
Funtions:
VLOOKUP
INDEX + MATCH
INDIRECT
and others.

To indicate a good solution for you is TOTALLY necessary to know about layout of your file.
Save a portion of you file at a free site, www.speedyshare.com , putting here a link to download.

Make sure you have data enough at file and put there how you desire the answer appears.
Thanks Mazzaropi