Get the value adjacent to the first non-blank cell in a row

[chingching831]

Hi,

There are two values I wanted to find out:

1. The first non-blank values in the range C5:AC5, which I successfully got it by using the formula in cell AK
2. The value adjacent to the first non-blank cell in the range C5:AC5, even though it's blank. For example, in cell AL, I want it to display the value "1,817" in cell AB. What is this formula?

Thanks!
SC

 

[Fluff]

How about

=INDEX(C5:AC5,MATCH(FALSE,ISBLANK(C5:AC5),0)+1)

 

[chingching831]

How about

=INDEX(C5:AC5,MATCH(FALSE,ISBLANK(C5:AC5),0)+1)

Didn't know it's that simple...thanks a lot!

 

[Fluff]

You're welcome & thanks for the feedback.