Excel Forum

Hi dear,
How are you doing today?hope everybody here doing well.
I have a question to ask for a solution.
I have list in column A I want to get them to column b and C as in attach file.


Thanks

...

B2
=IF(COUNT(LOOKUP(99,SEARCH({"-","TOTAL"},A2))),"",A2)


C2

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($B$2:$B$13)/(LOOKUP(ROW($B$2:$B$13),ROW($B$2:$B$13)/($B$2:$B$13<>""))=INDEX(LOOKUP(ROW($B$2:$B$13),ROW($B$2:$B$13)/($B$2:$B$13<>"")),ROWS($C$2:C2)))/($A$2:$A$13<>"TOTAL"&" "),ROW(B2)+2-INDEX(LOOKUP(ROW($B$2:$B$13),ROW($B$2:$B$13)/($B$2:$B$13<>"")),ROWS($C$2:C2)))),"")

Norkaz

thanks ,I will take a look