Help with formula(countif possibly,,although i'm not 100% sure but whatever gets it done)

Hello Guys,

Please see the files that I attached.

there are lots of data and I only need to extract information that I only need.

I only need MODEL and TOTAL QUANTITY

I will explain in the excel sheet.

thanks in advance!!

Put this formula in P3:

=IF(B3="Subtotal",COUNTIF(B$2:B3,B3),"")

then copy down to the bottom of your data by double-clicking the fill handle (the small black square in the bottom right corner of the cell cursor). Then put these formulae in the cells stated:

R3: =IFERROR(LOOKUP("zzz",INDIRECT("B$2:B"&MATCH(ROWS($1:1),P:P,0)-1)),"")
S3:=IF(R3="","",INDEX(O:O,MATCH(ROWS($1:1),P:P,0)))

then you can copy these two formulae down to row 160 (i.e. until you get blanks).

Hope this helps.

Pete