问题描述:
关于EXCEL中的MATCH和INDEX函数
{=INDEX(B2:B21,MATCH(MIN(D2:D21),D2:D21,0))}
和{=INDEX(E2:E21,MATCH(MIN(IF(H2:H21="女",D2:D21,TODAY())),D2:D21,0))}
{=INDEX(B2:B21,MATCH(MIN(D2:D21),D2:D21,0))}
和{=INDEX(E2:E21,MATCH(MIN(IF(H2:H21="女",D2:D21,TODAY())),D2:D21,0))}
问题解答:
我来补答展开全文阅读