Need only leave days one by one from leave attendace full data
hi,
i have all the employee data and their leave details date wise,
but now i want only leave dates one by one, if a person leave on 3rd and 17th, i need only these two dates next to his token number...
kindly look into my attachment and give me a solution...
thanks in advance...
sathya
Hello Sathiyamoorthy in leave dates C2
Copy paste below
=IFERROR(INDEX(data!$B$1:$AG$1,SMALL(IF(INDEX(data!$C$2:$AG$1604,MATCH($B2,data!$B$2:$B$1604,0),0)="L",COLUMN(INDEX(data!$C$2:$AG$1604,MATCH($B2,data!$B$2:$B$1604,0),0))-1),COLUMN(A1))),"")
then hold control and shift together and then hit enter and release all three keys to make it array formula. Now drag down and to right
Last edited by hemesh; 02-18-2014 at 02:59 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
hi hemesh,
thank you very much for your help
Thanks for the feedback and Rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks