Find the first value from a column

Question

Hi, guys,

Is there a formula which can be placed in the F column which can find the first value from E column whenever there's a value in C column? For example, the formula from F1 cell should add in the F1 cell the value from E2 cell, which is 456 and that's because I have a value in C1 cell. The value from E5 cell should be ignored. In the F7 cell, the formula should add the value from E8 cell which is 452 and that's because there's a value in C7 cell. The values from E10 and E11 should be ignored. The other cells from the F column should be empty ("").

Below is a sample from the table.

Can you help me, please?

Thank you!

Answer 1

In F1:

=IF(C1="","",INDEX(E1:E$1048576,MATCH(FALSE,ISBLANK(E1:E$1048576),0)))

Fill down.

Answer 2

Hello MiHai,

My name is Carl, and I am a volunteer forum member.

Can you tell us are there always the same amount of rows between Date Headers like Row 1 and Row 7. I so it is a fairly easy task.

The formula could be

=IF($C1<>"",INDEX($E1:$E7,MATCH(TRUE,INDEX(($E1:$E7<>""),0),0)),"")

Now if there are always five rows between header rows then select cells F1 to F6 then drag down till you fill the column.

I hope this helps.

CDN-Carl

Answer 3

Hello MiHai,

The formula that Hans supplied works easier since it is not dependent on the number of rows between headers.

CDN-Carl

Answer 4

Hi, HansV,

Thank you so much for the reply.

For whatever reason, when I add the formula in the sample table, it works. When I add it in my real table, it returns a white space. Here is the real table. I really can't understand why in the real table, the formula returns a blank cell instead of "HIT".

Am I missing something?

Thank you again.

Answer 5

Hi, Carl,

Thank you for the reply. The amount of rows between the Date Headers is not constant.

Thank you again.

Have a great time.