How to find out the data in six month record [Solved/Closed]

Report
-
 subodh -
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?


2 replies

Posts
1852
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 7, 2020
136
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!