'Find column of largest entry
I need help with the following function.
=COLUMN(LARGE(B6:F6,1))
I am trying to find the column number of the highest number in this array, but it always says:
Argument must be a range.
Solution 1:[1]
I am trying to find the column number of the highest number in this array
try:
=MATCH(MAX(B6:F6); A6:F6; 0)
update:
=MATCH(MAX(B6:F6); B6:F6; )+1
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |