Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Can you please help me to show the Max week number in text for the below, I need to display weeknumber
WeekNumber | YearNew |
01 | 2019 |
02 | 2019 |
03 | 2019 |
04 | 2019 |
52 | 2018 |
Thanks,
Gowtham
Not sure I understand, but shouldn't it be just
=Max(WeekNumber)
?
Or if you want the max weeknumber of the max year
=Max({<YearNew ={$(=Max(YearNew))}>} WeekNumber)