我想问下如果A B C D E F 80 65 55 40 30 18 95 70 65 53 44 26 107 98 84 72 65 53 128 104 93 82 70 68
我想问下如果A B C D E F 80 65 55 40 30 18 95 70 65 53 44 26 107 98 84 72 65 53 128 104 93 82 70 68
日期:2021-06-01 21:34:43 人气:1
=SMALL(INDIRECT("b"&MATCH(3,A1:A4,0)):INDIRECT("g"&MATCH(3,A1:A4,0)),COUNTIF(INDIRECT("b"&MATCH(3,A1:A4,0)):INDIRECT("g"&MATCH(3,A1:A4,0)),"<56")+1)