使用命名范围Rng和原始帖子中发布的值尝试此公式.

With a named range Rng and values as posted in original post try this formula.

=SUBTOTAL(4,OFFSET(INDEX(Rng,1,1),,COLUMN(Rng)-MIN(COLUMN(Rng)),ROWS(Rng)))

它返回每个列的最大值的数组. {4,5,6,7}

It returns an array of max of each column {4,5,6,7}

这将返回每一行的最大值.

This returns a max of each row.

=SUBTOTAL(4,OFFSET(INDEX(Rng,1,1),ROW(Rng)-MIN(ROW(Rng)),,,COLUMNS(Rng)))

和数组 {7; 6; 5; 4}.