Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, please help if you can
I need a way to find the second highest value in a date range.
So if this is the Table
Date
17/10/2012
14/10/2012
13/10/2012
11/10/2012
05/10/2012
I would want the formula to return 14/10/2012...
I might be over thinking this but I am not sure how to do this..
Thanks
Try this: =date(FirstSortedValue( [Date],-[Date],2),'DD/MM/YYYY')
Also make sure your date is really a date and not text. Use the date# function if necessary.
Try this: =date(FirstSortedValue( [Date],-[Date],2),'DD/MM/YYYY')
Also make sure your date is really a date and not text. Use the date# function if necessary.
Gysbert, thanks for this! it headed me in the right direction... I ended up using this:
=FirstSortedValue(DISTINCT [Date],-[Date],2)