April 4th, 2010, 04:05 AM
posted to microsoft.public.excel.newusers
|
|
|
using dmax
Consider a PivotTable;
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
--
Regards
Dave Hawley
www.ozgrid.com
"dbasmb" wrote in message
...
I want to find the max temperature for each day of the year over 10 years
worth of data. I can do it by using a criteria where the first in the
range
of the criteria is the label ("Date" in this case) and under that cell is
the
date I want to look up (eg "Jan,3"). But it seems like I need to have 2
cells per day of the year in order to specify each day. That is, it
looks
like I have to do it this way:
A B
1 Date
2 ="Jan,1" =dmax(H100:I465,2,A1:A2)
3 Date
4 ="Jan,2" =dmax(H100:I465,2,A3:A3)
5 Date
6 ="Jan,3" =dmax(H100:I465,2,A5:A6)
etc
Isn't there an easier way?
Thanks
Doug
|