Excel对应的列某一个单元格中不为空值,怎么提取这列某一行的文字?答:Excel版本低呢,就用我这个土一点的公式,N2单元格公式=TRIM(MID(IF(B2="","",","&B$1)&IF(C2="","",","&C$1)&IF(D2="","",","&D$1)&IF(E2="","",","&E$1)&IF(F2="","",","&F$1)&IF(G2="","",","&G$1)&IF(H2="","",","&H$1)&IF(I2=""...
excel中在表格中提取特定文字后的单元格中的内容?答:L2公式=INDIRECT(TEXT(MIN(IF($A$1:$I$17=$K2,(ROW($1:$17)+MATCH(L$1,OFFSET($A$1,MIN(IF($A$1:$I$17=$K2,ROW($1:$17)-1)),MIN(IF($A$1:$I$17=$K2,COLUMN($A:$I)-2)),9),)-1)*100+COLUMN($A:$I)+2,9^9)),"R0C00"),)数组公式,三键结束。横拉竖拉...