第1个回答 2011-08-13
给你个函数,自动提取筛选后的数据
空白单元格输入:
显示A列
=INDIRECT("A"&MAX(SUBTOTAL(103,(OFFSET(A3,ROW(INDIRECT("1:"&COUNTA(A3:A1000)))-1,)))*(ROW(INDIRECT("1:"&COUNTA(A3:A1000)))+2)))
显示B列
=INDIRECT("B"&MAX(SUBTOTAL(103,(OFFSET(B3,ROW(INDIRECT("1:"&COUNTA(B3:B1000)))-1,)))*(ROW(INDIRECT("1:"&COUNTA(B3:B1000)))+2)))
数组公式