excel怎么样提取有数字单元格对应行和列的内容答:J2=INDIRECT(TEXT(SMALL(IF($B$2:$G$16<>"",ROW($B$2:$G$16)*100+1,4^8),ROW(A1)),"r0c00"),)&INDIRECT(TEXT(MOD(SMALL(IF($B$2:$G$16<>"",ROW($B$2:$G$16)*100+COLUMN($B$2:$G$16),4^8),ROW(A1)),100)+100,"r0c00"),)&INDIRECT(TEXT(SMALL(IF($B$2:...