The last Value between Date to Date

[MAHMUZ]

Dear`s
As attached I need to write a formula in Cell [C6, C7 , C8 & c9] to get the following:

1-The Last value between [Date to Date] for each row.
2-If the last value is Null, then get the previous record value.
3-[Date To Date] can be changed based on user needs.

BR

[AliGW]

Are you still using Excel 2007?

[MAHMUZ]

Microsoft Excel for Microsoft 365.

[AliGW]

Thank you.

[AliGW]

In C6 copied down:

=XLOOKUP(B6,FILTER($1:$1,$2:$2<>""),FILTER($2:$2,$2:$2<>""),"",-1,-1)

[HansDouwe]

Another option, please try in C6 and copy down:

Please Login or Register  to view this content.

[MAHMUZ]

Are you still using Excel 2007?

Marvelous.
Many Thanks, working perfect.

[MAHMUZ]

Another option, please try in C6 and copy down:

Please Login or Register  to view this content.

Marvelous.
Many Thanks, working perfect.

[HansDouwe]

You are Welcome!

Thanks for the feedback and rep . Glad to have helped.

[Phuocam]

For Excel>=2003:

=LOOKUP(B6,$A$1:$CX$1/($A$2:$CX$2<>""),$A$2:$CX$2)

.

[wk9128]

Cell C6 formula , Drag down

Please Login or Register  to view this content.