Returning max. min value that meet certain conditions in two other columns

[AileenR]

I have hourly temperature data with the data currently in three columns as in month, day and hour. The next column contains temperature data. Is there an easy way to create a table/list of max and min temps for each day please. I am sorry the title is vague I don't know how else to explain it succintly! :-)

[dredwolf]

First off, read the rules, you are violating #1 : http://www.excelforum.com/forum-rule...rum-rules.html
Second, a sample including what you have and expected results would definitely help

Add a File - click advanced (next to quick post), scroll down until you see "manage attachments", click that and select "add files" (top right corner). click "select files", find your file, select file, click "upload", when the file shows up at the bottom left click 'done"(bottom right). click "submit reply"(remember the 1 MB limit, you may have to crop your file down to get it to a size that can be uploaded...)

[zbor]

AileenR,
you've uploaded example but also see first thing dreadwolf asked:

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[zbor]

Insert helper column to determine date and use Pivot table:

[Fotis1991]

Maybe in G2 and copy down this ARRAY formula

=MAX(IF($B$2:$B$10000=B2,IF($C$2:$C$10000=C2,IF($D$2:$D$10000=D2,$F$2:$F$10000))))

In H2 and copy down

=Min(IF($B$2:$B$10000=B2,IF($C$2:$C$10000=C2,IF($D$2:$D$10000=D2,$F$2:$F$10000))))

Edit: What is "Ferny Greek"?

[AileenR]

Thanks, much appreciated! I was trying to do it with pivot tables but you do it much better.

[AileenR]

Ferny Creek (not Greek) is a location in Melbourne near strawberry runner production

[Fotis1991]

Ferny Creek (not Greek) is a location in Melbourne near strawberry runner production

Thanks for the info!