Highlight Data at Intervals

[Lachln]

How do I highlight cells at intervals? Even better, how do I exclude all other data sets that aren't in my data interval?

I have collected some data of temperatures rising and I want to see the rate at which it takes to increase 0.5 degrees. So I need to emit all other data that isn't within the interval of 0.5 seconds I have two temperatures against a time increasing everyone 0.5 seconds.

My first temperature is 25.187 degrees Celsius at 0 seconds so the next cell I want to see is the time at which it is 25.687 degrees Celsius etc.

I don't really want to go through and sort it all by hand so I thought I would check out this forum and perhaps learn something new.

 

[RickXL]

Hi, and welcome to the MrExcel Message Board.

The usual way to select data at intervals is to use the =MOD() function. This calculates remainders after a division.

In your case I would convert the times into milliseconds so that you have some whole numbers to work on. Assuming the time is in column A then you will need something like this:
=MOD(A2,500)
Then every time column A is exactly divisible by 500 (0.5 seconds) the remainder will be 0. Then you select (AutoFilter) the rows which have 0 in the +MOD() column.
You will get problems if your times are never exactly divisible by 500 so you might have to be creative.

 

[Vidar]

Hi
If you are familiar with pivottables you can put the temperature column into "Row Labels" and group them by 0.5 degrees intervals.
Then put the time field in the "Values" field of the pivottable. It will then count how many time intervals there are in each 0.5 degrees group.
A low value will indicate a quick temperature rise, and a high value will indicate a slow temperature rise.