date, time and temp

[finavi]

What is the easiest way to lookup different temperature ranges during a series of days and hours?

 

[Joe4]

Welcome to the Board!

I think you will need to provide more details.
Are you working off of some files of data that you have?
What do they look like? How is the data laid out?
Posting examples may be helpful.

Then explain what it is you are looking for, and what your expected results would look like.

 

[finavi]

There are three columns (date, time and temp). I need to search for a temp range and calc time it stayed in range.

 

[Joe4]

How about using Conditional Formatting?

Let's say that data is in column A-C and in rows 2-100.
You could have a cell, let's say E1 where you enter in the temperature you want to look for.

Then if you highlight rows 2-100, and go to Conditional Formatting, select the Formula option and enter the following formula:
=$E$1=$C2
Then select your formatting option (i.e. yellow highlight).

Now whenever you enter your desired temperature in E1, it will highlight all rows matching that temperature yellow.

If you do not want to highlight the rows, but rather just display the matching rows, you could use Filters instead.

 

[finavi]

Will not work

 

[Joe4]

I am sorry, but you really have not given us very much to go on. The key to getting a good answer is to be clear and detailed in exactly what you are working, and exactly what expect to get back. I had asked if you could post some sample data, and what you are expecting to get back, but you have not done that.

There is a link here that explains how you can post screen shots:
http://www.mrexcel.com/forum/showthread.php?t=508133