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

1. ## 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

Thanks,

2. ## Re: Need Formula for MAX,MIN,START & END values for Yearly

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.

3. ## Re: Need Formula for MAX,MIN,START & END values for Yearly

Hi Dave,

Thanks you so much for your work. It's working perfect except for cells B2 & E2 , reaming all cells are working perfect.

01.JPG

Correct values
02.JPG

Can you please check and confirm , it will be very help full to me.

4. ## Re: Need Formula for MAX,MIN,START & END values for Yearly

and also can you please do the formulas in the same Sheet.

5. ## Re: Need Formula for MAX,MIN,START & END values for Yearly

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).

6. ## Re: Need Formula for MAX,MIN,START & END values for Yearly

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).

7. ## Re: Need Formula for MAX,MIN,START & END values for Yearly

Thanks Dave for your work it helped me a lot...

There are currently 1 users browsing this thread. (0 members and 1 guests)