...a中查找某个数,若找到,则输出该数在数组中的位置,否则输出"查无此数...答:include <stdio.h> int main(){ int i,n,a[8] = {25,21,57,34,12,9,4,44};printf("请输入待查找的数n:");scanf("%d",&n);for(i = 0; i
如何在EXCEL里查询数组中某一特定值的单元格位置?答:有一表格如下图。要求在G2设置公式,使得根据F2的数值查找B1:D3范围内该数值对应的单元格地址。G2的公式:=ADDRESS(LOOKUP(0,0/COUNTIF(OFFSET($B$2:$D$4,ROW($B$2:$D$4)-ROW($B$2),,1),F2),ROW($B$2:$D$4)),LOOKUP(0,0/COUNTIF(OFFSET($B$2:$D$4,,COLUMN($B$2:$D...