获取非隐藏单元格的最大值-Getthemaxvalueofun-hiddencells

I have a table that has 20 rows and the table un-hides the amount of rows specified in the cell above my table. so if I put in 5 into the cell, 5 of the 20 rows will be un-hidden. So now I would like to get the MAX of the say 5 cells that are now unhidden. How would I do this?

我有一个有20行的表，该表取消隐藏在我的表上方单元格中指定的行数。因此，如果我将5放入单元格，则20行中的5行将被取消隐藏。所以现在我想得到现在不隐藏的5个单元格的MAX。我该怎么办？

2 个解决方案