| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding one same data to each of four other data points in column c | Charts and Charting in Excel | |||
| Column chart not displaying some data points - Excel 2003 | Charts and Charting in Excel | |||
| I would like a function to return a value that fits its range | Excel Worksheet Functions | |||
| nonlinear regression/ curve fits | Excel Discussion (Misc queries) | |||
| Making an alphabetical list that fits on one page. | New Users to Excel | |||
Linear Mode
