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

  • Thread starter Thread starter Filip Houdek
  • Start date Start date
F

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".
 
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".
Click to expand...

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


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif, index and match 2
MACRO RUN random percentage and copy of column values 1
lookup and return column number 2
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
How to give count of lines before all 5 values pass?? 18
Last Number in Column 2
I copied Visible Cells Only, but it pastes only the first cell 1
Changing column reference for number of formulas at once 1

Back
Top