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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating A List of Items Between Two Numbers 2
one of two criteria 11
HOWTO: What is the formula to have evaluate a range of value 8
two-variable data table question 7
Difference between two times in seconds 1
Count Non-Blank Cells in Column If a Reference Criteria Met. 5
creating nested formulas from drop down box 5
Filtering data based on formula 1

Back
Top