Get largest value from a list with at least 2 entries

I have table with consecutive counting months and days and I use the LINEST function to calculate the linear regression of the latest month but it doesn't work very well when a month have only one entry. This is the reason why I'm looking for a way to get the largest value from a list (the months) but only if it has at least two points (two enrties).
Here something more concrete, the table looks like something like this one:

Month	Day	Value
2	33	20
2	45	24
2	54	27
3	65	30
3	78	35
3	87	39
4	92	45

I use the LINEST function with the FILTER function to calculate the linear regression of the last month.

Please Login or Register  to view this content.

With this formula the LINEST function returns for the 4th month the values 0 and 45, what actually a quite useless linear regression is.
In this case I would like to have the linear regression still starting from the 3rd month although there is already a entry in the 4th month.

What I'm looking for is to replace the

Please Login or Register  to view this content.

with a formula which returns 3 instead of 4 if there is only one entry for the largest value.

Thanks in advance

If you are using FILTER then you are no longer using Excel 2016 - what are you using now? Please update your profile.

Is this substantially different to your previous thread?

Can you post an excelfile instead of an formula ?
It'll be a compounded "aggregate"-formula

We've been waiting for you to confirm your Excel version!

Now that you have, can you please tell us the results (values) that you would want returning in the sample workbook?

A also asked you if this question is substantially different to your prevous thread - you need to respond to a moderator's questions, please.

OK - thanks for letting us know.

Please close the thread by marking it as solved. Thanks.

Please Login or Register  to view this content.

Edit : i modified my post !