Excel列引用(而不是值) [英] Excel column references (instead of value)

问题描述

我正在寻找一种在Excel中获取列引用的方法.

I am searching for a way to obtain column-references in Excel.

我想搜索一行(B12:G12)并寻找最大的数字.这可以通过MAX公式来完成.但是我想获取该单元格的列引用，而不是该值，例如B，C，D，E，F，G.有没有办法做到这一点?我已经尝试过Address-/和Index-Formula，但这没用.

I would like to search through a row (B12:G12) and look for the highest number. That could be done with the MAX-formula. But instead of the value, I would like to get the column reference of that cell, like B, C, D, E, F, G. Is there a way to do that? I already tried the Address-/ and Index-formula, but that didn't work.

非常感谢和问候！

推荐答案

这将告诉您哪些列索引在数组中具有最大值.

This will tell you what Column Index has the max value inside the array.

=MATCH(MAX(B12:G12),B12:G12)

请注意，此处的索引从 B = 1，C = 2，等等开始.因此，如果要实际的列索引(即，使 A = 1 >)，然后将1加到方程式的末尾

Note the index here starts at B = 1, C = 2, etc. so if you want the actual column index (i.e. such that A = 1) then just add 1 to the end of the equation

您还可以通过将值与 CHAR 索引与

You can also output the actual column letter reference by associating the value to the CHAR index with

=CHAR(MATCH(MAX(B12:G12),B12:G12)+65)

---

这篇关于Excel列引用(而不是值)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！