check what the arguments of 'offset' mean:

=(MAX(SUBTOTAL(1,OFFSET(E8,,COLUMN(INDIRECT("8:265")),6,1))))