Weird outcome with Large function
I am experiencing a weird scenario while trying to use the Large function. What I want to do is to get the two most recent dates from a column with numerous dates. Please check the sample datasheet:
The Dates column contains the dates and I am showing the two most recent dates in the column Recent Dates. I am using the following two formulas for that, and it is working fine with this dataset as you see.
=LARGE(Dates:Dates, 1) which gave me the most recent date, 06/07/21
=LARGE(Dates:Dates, 2) which gave me the second most recent date, 05/24/21
Up to this point the function is working fine and showing accurate outcome. However, please see the below dataset and outcome:
The formulas are the same, and the outcome should be 05/24/21 as most recent date, and 05/17/21 as the second most recent date. But it is showing 05/24/21 for the both. I have tried adding new rows with new past dates, but always it remains as 05/24/21 for both the values. So, the function is not working. I have saved the sheet after any changes, without any difference.
I was just wondering what could be the issue here. Anyone with any idea regarding this? Thank you.
Help Article Resources
Check out the Formula Handbook template!