• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to find 1st value in range of cells???

S

Smitty15

New Member
I have a range of cells from rows 5:88 and columns A:Z. The range looks some like this...


#NA ; #NA ; #NA ; 1 ; 5

1 ; 9 ; #NA ; #NA ; #NA

#NA ; #NA ; 7 ; 3 ; #NA


Etc....


Is there a formula that returns the 1st cell that equals an actual number?
 
You mean first cell in each column?


then you can use,


=INDEX(A5:A88,match(true,isnumber(a5:a88),0))


You need to array enter the formula (press CTRL+SHIFT+Enter after typing it).
 
Chandoo, you are awesome!!! This is exactly what I need! :)


How could I do this but return the next number in the array (i.e. the second number)?
 
Nevermind on that one! I fiddled around and figured out how this works now. Finally I'm starting to get how all these formulas are connecting my data together.


Thank you Chandoo for the patience and help! You really are a great person for being there for your community.
 
You must log in or register to reply here.
Back
Top