Max Month when Year is the MAX Year
This should work in 2016
=MAX(IF(Table1[YEAR]=MAX(Table1[YEAR]),Table1[MONTH_NUMBER],0))
Max Month when Year is the MAX Year
This should work in 2016
=MAX(IF(Table1[YEAR]=MAX(Table1[YEAR]),Table1[MONTH_NUMBER],0))
-If you think you are done, Start over - ELeGault
Excellent!! Thank you!
I was working with the IF function, but could not get it to work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks