Need Formula for MAX,MIN,START & END values for Yearly

Hi All,

I Need help to get formula for MAX,MIN,START & END values for Yearly. AS i have a sheet with daily values for years 2018 and 2019 as below
01.JPG

I need formula to get the results as below
02.JPG



can anyone please help on this..

Thanks,

In Cell B2

=MAX(IF(YEAR(Sheet1!$A$2:$A$1058)=$A2+0,Sheet1!$B$2:$B$1058,""))

In Cell C2

=MIN(IF(YEAR(Sheet1!$A$2:$A$1058)=$A2+0,Sheet1!$B$2:$B$1058,""))

In Cell D2

=VLOOKUP(MIN(IF(YEAR(Sheet1!$A$2:$A$1058)=$A2+0,Sheet1!$A$2:$A$1058,"")),Sheet1!$A$2:$B$1058,2,0)

In Cell E2

=VLOOKUP(MAX(IF(YEAR(Sheet1!$A$2:$A$1058)=$A2+0,Sheet1!$A$2:$A$1058,"")),Sheet1!$A$2:$B$1058,2,0)

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

Sorry Dave, i haven't read your post fully, now i corrected the issue and also can you please do the formulas within the same Sheet (Sheet1).

Originally Posted by click2chaitu

Sorry Dave, i haven't read your post fully, now i corrected the issue and also can you please do the formulas within the same Sheet (Sheet1).

Please see the file attached