How to find out the data in six month record ?

General discussion on MS Excel and its spreadsheets.

How to find out the data in six month record ?

Postby Bryan L. Warfield » Thu Nov 20, 2014 10:01 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 ?

Any suggestion.
Bryan L. Warfield
 
Posts: 29
Joined: Mon Mar 24, 2014 6:11 am

Re: How to find out the data in six month record ?

Postby Jill R. Lipe » Wed Nov 26, 2014 10:59 am

Hello Everyone,

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 , putting here a link to download.

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


thanks,
Jill R. Lipe
 
Posts: 33
Joined: Mon Mar 24, 2014 6:30 am


Return to MS Excel- Help Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron