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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks