LinkBack URL
About LinkBacks
One more
=IF(AND(ROWS(D$4:D4)<=$L$2,Data!$Z$2:$Z$20000>=$H$2),INDEX(Data!B$2:B$6372,SMALL(IF(Data!$A$2:$A$6372=$E$2,IF(Data!$E$2:$E$6372=$G$2,ROW(Data!$E$2:$E$6372)-ROW(Data!$E$2)+1)),ROWS($D$4:D4))),"")
One more
=IF(AND(ROWS(D$4:D4)<=$L$2,Data!$Z$2:$Z$20000>=$H$2),INDEX(Data!B$2:B$6372,SMALL(IF(Data!$A$2:$A$6372=$E$2,IF(Data!$E$2:$E$6372=$G$2,ROW(Data!$E$2:$E$6372)-ROW(Data!$E$2)+1)),ROWS($D$4:D4))),"")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks