LinkBack URL
About LinkBacks
If Crt from B:B is I3, I need formula at T5, to the left.....
If Crt from B:B is I3, I need formula at T5, to the left.....
Unable to understand your desired output and the conditions
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Perhaps,
1] In Q5, CSE formula copied across right to T5
=AGGREGATE(14,6,LOOKUP((ROW($1:$5)-1),MMULT(N(COLUMN($A:$E)<ROW($1:$6)),TRANSPOSE(INDEX($C$4:$G$7,MATCH($I$3,$B$4:$B$7,0),0))),$C$3:$G$3),COLUMN(A1))
2] and, in P6 used the same CSE formula, copied across right to S6
Regards
Bosco
Thank you so much but I messed up !
So I have reattached the file.
It the same but VERTICAL
Last edited by ionelz; 09-04-2019 at 07:38 AM.
The revised vertical Result Table can narrow down to one table with 2 dropdown list for selection, please see my attached file.
1] I5, CSE formula copied down :
=IF(ROWS($1:1)<=SUM(INDEX($C$4:$G$7,MATCH(I$3,$B$4:$B$7,0),0))*J$3,LOOKUP(MOD(ROWS($1:1)-1,SUM(INDEX($C$4:$G$7,MATCH(I$3,$B$4:$B$7,0),0))),MMULT(N(COLUMN($A:$E)<ROW($1:$6)),TRANSPOSE(INDEX($C$4:$G$7,MATCH(I$3,$B$4:$B$7,0),0))),$C$3:$G$3),"")
2] J4 CSE formula copied down :
=IF((I4<>"")*(I5=""),"Stop",IF(ROWS($1:1)<=SUM(INDEX($C$4:$G$7,MATCH(I$3,$B$4:$B$7,0),0))*J$3,LOOKUP(MOD(ROWS($1:1)-1,SUM(INDEX($C$4:$G$7,MATCH(I$3,$B$4:$B$7,0),0))),MMULT(N(COLUMN($A:$E)<ROW($1:$6)),TRANSPOSE(INDEX($C$4:$G$7,MATCH(I$3,$B$4:$B$7,0),0))),$C$3:$G$3),""))
Regards
Bosco
Last edited by Bosco; 09-04-2019 at 11:05 AM.
Thank you so much !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks