Nth biggest daily value

**harvy84** · 01-12-2013, 05:33 AM

Hi everybody! I have 15-min values of temperature for 9 years,and i need to find the 5th max and min value of every day, any ideas? :/ Thanx in advance!

**dilipandey** · 01-12-2013, 05:45 AM

Hi harvy84,

welcome to the forum.
Try looking at Large function where you can use it as =large(reference to data, 5)... in case of any issues, upload the sample workbook. thanks.

Regards,
DILIPandey
<click on below * if this helps>

**harvy84** · 01-12-2013, 08:07 AM

Hi! Many thanx for your interest and help! The problem is that i have to do this for every day seperately and its a very large number of days :/ Is there any way to make this function work for every day automatically? Here is a sample of the data.

sample Ta.xlsx

**dilipandey** · 01-12-2013, 08:17 AM

Okay.. see the attached file

sample Ta.xlsx

Regards,
DILIPandey
<click on below * if this helps>

**MarvinP** · 01-12-2013, 08:39 AM

Hi Harvy and welcome to the forum,

Using Excel 2010, which has better Pivot Table features find your answer. You Filter and Sort the Pivot data using Top/Bottom 5 values of the Min and Max. Hope this example lets you discover how to do this problem. No formulas needed!!!