from vertical into horizonal results from index/match

[KDS14589]

I am thinking of redesigning a worksheet I have been designing lately. I had help with the original formula by one of the Mr. Excels moderators,
IFERROR(INDEX($BA$31:$BA$43,AGGREGATE(15,6,(ROW($BA$31:$BA$43)-ROW($Q$31)+1)/($Q$31:$Q$43<=$L$54)/($Q$31:$Q$43>=$L$53)/($BA$31:$BA$43<>"Angi"),ROWS(A$2:A2))),"")

This formula list results vertically, but now I wish it to list horizontally starting in FM14 and with more results in columns every 3rd apart. I've tried several solutions but none have worked. What do I need to change?

 

[Radoslaw Poprawski]

without the sampla data its hard to guess.
Maybe

=transpoze()

will work for you?

 

[Rahul1987]

I am thinking of redesigning a worksheet I have been designing lately. I had help with the original formula by one of the Mr. Excels moderators,
IFERROR(INDEX($BA$31:$BA$43,AGGREGATE(15,6,(ROW($BA$31:$BA$43)-ROW($Q$31)+1)/($Q$31:$Q$43<=$L$54)/($Q$31:$Q$43>=$L$53)/($BA$31:$BA$43<>"Angi"),ROWS(A$2:A2))),"")

This formula list results vertically, but now I wish it to list horizontally starting in FM14 and with more results in columns every 3rd apart. I've tried several solutions but none have worked. What do I need to change?

Pls provide some of the dummy data to understand required output

 

[Rahul1987]

Pls provide some of the dummy data to understand required output

maybe in this case you will to try Column & Columns instead of Row & Rows to obtain horizontal result

 

[Fluff]

If you want the formula in every 3rd column you can use this in FM14

=IFERROR(INDEX($BA$31:$BA$43,AGGREGATE(15,6,(ROW($BA$31:$BA$43)-ROW($Q$31)+1)/($Q$31:$Q$43<=$L$54)/($Q$31:$Q$43>=$L$53)/($BA$31:$BA$43<>"Angi"),1)),"")

then in the next column use

=IFERROR(INDEX($BA$31:$BA$43,AGGREGATE(15,6,(ROW($BA$31:$BA$43)-ROW($Q$31)+1)/($Q$31:$Q$43<=$L$54)/($Q$31:$Q$43>=$L$53)/($BA$31:$BA$43<>"Angi"), 2)),"")

just keeping changing the final number from 1 to 2 to 3 etc.

 

[KDS14589]

If you want the formula in every 3rd column you can use this in FM14

=IFERROR(INDEX($BA$31:$BA$43,AGGREGATE(15,6,(ROW($BA$31:$BA$43)-ROW($Q$31)+1)/($Q$31:$Q$43<=$L$54)/($Q$31:$Q$43>=$L$53)/($BA$31:$BA$43<>"Angi"),1)),"")

then in the next column use

=IFERROR(INDEX($BA$31:$BA$43,AGGREGATE(15,6,(ROW($BA$31:$BA$43)-ROW($Q$31)+1)/($Q$31:$Q$43<=$L$54)/($Q$31:$Q$43>=$L$53)/($BA$31:$BA$43<>"Angi"), 2)),"")

just keeping changing the final number from 1 to 2 to 3 etc.

It works, THANKS

 

[Fluff]

You're welcome & thanks for the feedback.