Return the last value for each day

[joseulloa22]

Hello, As per the attachment, I would like column F to pull (from Column D) and show the ending balance for each day for each Branch#. Notice that there are variables regarding Branch# (Column A) and Completion/Ship dates (Column E).
Thanks in advance for you help.

Joe U

 

[etaf]

can you give the examples of what you want the results to look like and based on the sample what the results expected are ?

 

[JEC]

In F3 to pull down

=IF(A3&E3<>A4&E4,D3,"")

 

[joseulloa22]

can you give the examples of what you want the results to look like and based on the sample what the results expected are ?

In F3 to pull down

=IF(A3&E3<>A4&E4,D3,"")

Thanks JEC. It works to perfection

 

[joseulloa22]

can you give the examples of what you want the results to look like and based on the sample what the results expected are ?

Hi ETAF, I tried to download the XL2BB but I was unnsuccesful. But thanks for your help. I got the answer from JEC
Regards
Jose