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
1942
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 2, 2021
145
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