In column A, I have numbers 1-400. In column B, I have my data.
I want to, in column C, return the value in column A for the first value in B that is greater than 0. How can I do this?
In column A, I have numbers 1-400. In column B, I have my data.
I want to, in column C, return the value in column A for the first value in B that is greater than 0. How can I do this?
Try:
=INDEX(A:A,MATCH(1,INDEX(ISNUMBER(B:B)*(B:B>0),0),0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks