Duplicate rank what formula would return the most recent week?
I have a formula to return the date of the 5 highest ranking weeks. Two weeks are both ranking as the 5th week as they both have the same result. Currently it is returning the oldest of the two dates. Is there a way to get the most recent week instead?
Help Article Resources
Check out the Formula Handbook template!