summarize information based on criteria using excel

[zhengzhi8806]

Hi experts~
I have a problem with excel. I attatched the excel sheet to show the question.

Thanks everyone!!excel problem.xlsx

[Ace_XL]

In C10

=IF(COLUMNS($A1:A1)>COUNTIF($B2:$K2,"x"),"",INDEX($B$1:$K$1,SMALL(INDEX(($B2:$K2="x")*(COLUMN($B2:$K2)-COLUMN($B$2)+1),),COUNTIF($B2:$K2,"<>"&"x")+COLUMNS($A1:A1))))

Copy down and across

[sktneer]

Another way........

Please Login or Register  to view this content.

This is an array formula so it needs to be confirmed with Ctrl+Shift+Enter and then copy across and down.