UC知道excel问题，用什么公式找出在A1:F15最大值和最大值所在的单元格，请高手指教
来源：百度知道 编辑：UC知道 时间：2024/06/17 05:25:27
A B C D E F
1 91.3% 73.9% 87.0% 78.3% 91.3% 73.9%
2 91.3% 69.6% 82.6% 78.3% 78.3% 69.6%
3 73.9% 69.6% 82.6% 73.9% 73.9% 65.2%
4 69.6% 65.2% 69.6% 73.9% 65.2% 60.9%
5 65.2% 60.9% 60.9% 69.6% 65.2% 60.9%
6 77.3% 45.5% 50.0% 45.5% 45.5% 40.9%
7 68.2% 40.9% 40.9% 97.40% 36.4% 40.9%
8 59.1% 27.3% 31.8% 31.8% 36.4% 40.9%
9 54.5% 27.3% 31.8% 27.3% 36.4% 40.9%
10 50.0% 27.3% 31.8% 27.3% 36.4% 36.4%
11 40.9% 50.0% 40.9% 40.9% 45.5% 36.4%
12 40.9% 40.9% 40.9% 36.4% 40.9% 36.4%
13 36.4% 36.4% 36.4% 36.4% 36.4% 36.4%
14 27.3% 31.8% 31.8% 36.4% 31.8% 36.4%
15 18.2% 27.3% 31.8% 27.3% 31.8% 36.4%
在这里最大值是97.4％，最大值所在的单元格是D7
请教用什么公式
1 91.3% 73.9% 87.0% 78.3% 91.3% 73.9%
2 91.3% 69.6% 82.6% 78.3% 78.3% 69.6%
3 73.9% 69.6% 82.6% 73.9% 73.9% 65.2%
4 69.6% 65.2% 69.6% 73.9% 65.2% 60.9%
5 65.2% 60.9% 60.9% 69.6% 65.2% 60.9%
6 77.3% 45.5% 50.0% 45.5% 45.5% 40.9%
7 68.2% 40.9% 40.9% 97.40% 36.4% 40.9%
8 59.1% 27.3% 31.8% 31.8% 36.4% 40.9%
9 54.5% 27.3% 31.8% 27.3% 36.4% 40.9%
10 50.0% 27.3% 31.8% 27.3% 36.4% 36.4%
11 40.9% 50.0% 40.9% 40.9% 45.5% 36.4%
12 40.9% 40.9% 40.9% 36.4% 40.9% 36.4%
13 36.4% 36.4% 36.4% 36.4% 36.4% 36.4%
14 27.3% 31.8% 31.8% 36.4% 31.8% 36.4%
15 18.2% 27.3% 31.8% 27.3% 31.8% 36.4%
在这里最大值是97.4％，最大值所在的单元格是D7
请教用什么公式
最大值所在单元格=ADDRESS(MAX(IF(A1:F15=MIN(A1:F15),ROW(1:15))),MAX(IF(A1:F15=MIN(A1:F15),COLUMN(A:F))),4)
最小值所在单元格=ADDRESS(MAX(IF(A1:F15=MIN(A1:F15),ROW(1:15))),MAX(IF(A1:F15=MIN(A1:F15),COLUMN(A:F))),4)
都是数组公式，公式在编辑状态下按CTRL+SHIFT+ENTER结束
选中旁边一个单元格，然后输入“=MAX(A1:F15)”
ok，请加分，谢谢你！我只是个初中没有毕业的小混混，试试吧！