Hello,
You all have been very helpful to me in the past and I need a little change to one of my formula that I do not know how to translate.
I have a list of persons and need to create a list depending on different factor (the school, the day, AM or PM )
The formula I have here is almost working except that I need to be able to split it between AM and PM or FULL(Full day).
I attached a example.
Thank you in advance
Please try at
M5
=IFERROR(AGGREGATE(15,6,ROW($C$5:$C$17)/($C$5:$C$7=$L$2)/(INDEX($E$5:$I$17,,MATCH($L$3,$E$4:$I$4,))<>""),ROWS(K$5:K5))-ROW($C$4),"")
K5:L5
=IF($M5="","",IF(INDEX($D$5:$D$17,$M5)=INDEX($K$4:$L$4,COLUMNS(K$4:$L$4)),"",INDEX($B$5:$B$17,$M5)))
Thank you very much Bo_Ry,
It is working well,
however I was hopping for something more clean ? like the example I have (except that it will consider AM and PM or Full day)
I like that their is only one formula and that it will not leave blank spaces.
I hope to not be to needy and appreciate the work you've done, I would never be able to do write a quarter of that and I am very thankful for all of you, brainstorm of the excel world
Let me know if that make sense.
English is not my native language.
Please try at K5:L5 , one formula
Formula:
Please Login or Register to view this content.
It work perfectly.
Thank you very much !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks