Excel 2007 : How to pull data from this large list?

**jmccalip** · 06-27-2011, 08:24 AM

I've exhuasted what minimal knowledge I have.

See attachment:

I have this list, and I need to automatically pull out the earliest and latest local time for each day pf the month, and the value(35.3 for example) associated with that. The problem is I have a 30k row list. Anyone know what forumla(s) would work for this? Thanks

**romperstomper** · 06-27-2011, 08:36 AM

See attached - the first two have to be array-entered with Ctrl+Shift+Enter.

**jmccalip** · 06-27-2011, 08:49 AM

Originally Posted by romperstomper

See attached - the first two have to be array-entered with Ctrl+Shift+Enter.

Wow, thanks for the quick reply. That is almost perfect, I almost had it right with a "Min" "If" formula. Oh well.

But still, the list continues through everyday of the month, how do I get the formula to go through all days individually? IE, 2/22/2011, 2/23/2011. 2/24/2011, ect to find the data.

Thank you!

**romperstomper** · 06-27-2011, 09:05 AM

You'll need to create a unique list if that's what you need. A pivot table would be a simple way of getting a unique list of dates and their min and max local times, then you would just need the additional two formulas alongside.