Need a Formula for Determining starting and Ending Values year wise.

The dates for both A and B ranges being the same in col A, the starting year is the same for both? What is the correlation between values in ranges A and B and the dates? Perhaps manually add some desired results?
Starting days of each year are returned by

Formula:

Please Login or Register  to view this content.

pulled down

You can use this array* formula in cell F2:

=VLOOKUP(MIN(IF((YEAR($A$2:$A$1365)=$E2)*(B$2:B$1365>0)*(ISNUMBER(B$2:B$1365)),$A$2:$A$1365)),$A:B,COLUMNS($A:B),0)

*Note that an array formula needs to be confirmed using the key combination Ctrl-Shift-Enter, rather than the usual Enter.

Copy into G2, then copy the two formulae down.

A similar array* formula for J2:

=VLOOKUP(MAX(IF((YEAR($A$2:$A$1365)=$I2)*(B$2:B$1365>0)*(ISNUMBER(B$2:B$1365)),$A$2:$A$1365)),$A:B,COLUMNS($A:B),0)

(changes is red). Copy into K2, then copy both formulae down as required.

Hope this helps.

Pete

Like this?
My request was that YOU add some expected results manually to be sure.
Anyway have a look at the attached

Hi Pete,

Thanks for the solution. That helped me a lot.

Thanks.

Hi Pete_UK,

Thanks for the solution. That helped me a lot.

Thanks.

Originally Posted by click2chaitu

... Thanks for the solution...

You're welcome - thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete

Cell F2

Please Login or Register  to view this content.

Cell J2

Please Login or Register  to view this content.