How do I list all Data in a column that fits between two points?
 

I am graphing a thermal profile for a temperature chamber and need only the
data that fits between two dates and times. I am using an IF statement but I
have to use it on each cell that contains thermal data.

=IF((AND(A1='Test Criteria'!$C$7,A1<='Test Criteria'!$C$8)),A1,NA())

Is there a way I can do this without copying this formula into 8000 cells?

How do I list all Data in a column that fits between two points?
 

why don't you sort the data first. Then the range of data will be in
consecutive rows. Then plot only the dates and times you want.

"Jason" wrote:

I am graphing a thermal profile for a temperature chamber and need only the
data that fits between two dates and times. I am using an IF statement but I
have to use it on each cell that contains thermal data.

=IF((AND(A1='Test Criteria'!$C$7,A1<='Test Criteria'!$C$8)),A1,NA())

Is there a way I can do this without copying this formula into 8000 cells?

How do I list all Data in a column that fits between two point
 

The data is already sorted, I'm trying to save a couple steps, I have to do
this every couple of days for multiple sets of data points. I am just trying
to simplify the process.

"Joel" wrote:

why don't you sort the data first. Then the range of data will be in
consecutive rows. Then plot only the dates and times you want.

"Jason" wrote:

I am graphing a thermal profile for a temperature chamber and need only the
data that fits between two dates and times. I am using an IF statement but I
have to use it on each cell that contains thermal data.

=IF((AND(A1='Test Criteria'!$C$7,A1<='Test Criteria'!$C$8)),A1,NA())

Is there a way I can do this without copying this formula into 8000 cells?