How do I use "column" function to get the column number of the firstcell matching criteria?

[Filip Houdek]

I want to find the column number of the first cell containing a number
greater than a specified number. How would I do this?
Example: Row A1-E1 contains 5 10 15 20 25, and I want to find the
column number of the first cell greater than 10. This would be cell
C1, so I want the result "3".

 

[Claus Busch]

Hi,

Am Tue, 1 May 2012 22:07:06 -0700 (PDT) schrieb Filip Houdek:

I want to find the column number of the first cell containing a number
greater than a specified number. How would I do this?
Example: Row A1-E1 contains 5 10 15 20 25, and I want to find the
column number of the first cell greater than 10. This would be cell
C1, so I want the result "3".

try:
=MATCH(LARGE(A1:E1,COUNTIF(A1:E1,">"&10)),A1:E1,0)


Regards
Claus Busch

 

[Ron Rosenfeld]

I want to find the column number of the first cell containing a number
greater than a specified number. How would I do this?
Example: Row A1-E1 contains 5 10 15 20 25, and I want to find the
column number of the first cell greater than 10. This would be cell
C1, so I want the result "3".

You can do this with an array formula.

This formula must be **array-entered**:

=MATCH(TRUE,1:1>10,0)
----------------------------------------

To **array-enter** a formula, after entering
the formula into the cell or formula bar, hold down
<ctrl><shift> while hitting <enter>. If you did this
correctly, Excel will place braces {...} around the formula.