how to get specific absent dates from employees attendance data.CHECK EXAMPLE
how to get specific absent dates from employees attendance data.CHECK EXAMPLE
Perhaps something like this? pls see the file attach
Regards
Azumi
Thanks you very much azumi boss. I got it
and i got that absent dates in coloum? ( ai ) only one coloum like that 01/05/2014,2/05/2014,3/05/2014 if possible plz help me
Yes in which column? sorry not clear about what you need
dear azumi .
in My example attendance IN last coloum ( AI) i need total "A"dates in this coloum (AI). like that
abt on 01/05/2014,05/05/2014,10/05/2014
its possible plz help me.
PLZ CHECK MY EXAMPLE ATTENDANCE SHEET
Put in Cell AI2 and copied down:
=COUNTIF(D2:AH2,"="&"A")
something like that?
dear azumi
THANKS FOR REPLY. BUT I NEED TO ABSENT DATES NOT TOTAL ABSENT
Ooops sorry, please see the file attach.....
Regards
dear azumi
thanks a lots for help me. you are really genius. its working thanks again.
Ah yes glad it works hehe...
best regards
Azumi
Hi,
Pls help me out in getting absent dates data from the below example:
Capture.JPGCapture.JPG
File Attached herewith.
Administrative Note:
Hello Ranichandra and Welcome to Excel Forum.
We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.
Please see Forum Rule #4 about hijacking and start a new thread for your query.
If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks