Snasui Excel Forum

Hi Dear,

I need your help to solve the problem like attached .I have data a1:e5.i want to extract results like below as in attached.
Is it possible with formula?

Thanks

..

A8

=IFERROR(IF(INDEX($A$1:$A$5,AGGREGATE(15,6,ROW($2:$5)/($B$2:$E$5<>""),ROW(1:1)))=A7,"",INDEX($A$1:$A$5,AGGREGATE(15,6,ROW($2:$5)/($B$2:$E$5<>""),ROW(1:1)))),"")

B8

=IFERROR(INDEX($A$1:$E$1,AGGREGATE(15,6,COLUMN($B:$E)/(INDEX($B$1:$E$5,AGGREGATE(15,6,ROW($2:$5)/($B$2:$E$5<>""),ROW(1:1)),0)>0),ROW(9:9)-IF(A8="",ROW(7:7),ROW(8:8)))),"")

C8

=IFERROR(INDEX($A$1:$E$5,AGGREGATE(15,6,ROW($2:$5)/($B$2:$E$5<>""),ROW(1:1)),AGGREGATE(15,6,COLUMN($B$1:$E$1)/(INDEX($B$1:$E$5,AGGREGATE(15,6,ROW($2:$5)/($B$2:$E$5<>""),ROW(1:1)),0)>0),ROW(9:9)-IF(A8="",ROW(7:7),ROW(8:8)))),"")

Norkaz

thank you