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
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 16, 2020
135
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