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

J

Jason

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

Joel

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

Jason

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

How to pull in data from rows and columns if there are blanks? 0
Filtering data based on historical values 1
Creating A List of Items Between Two Numbers 2
two-variable data table question 9
How do I average hourly data into daily data? 1
How do I set up the percentage correctly in this spreadsheet? 2
Calculate Holding Period Returns Between Two Customizable Dates 1
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1

Top