Thread: How do I list all Data in a column that fits between two points?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
  
Posts: 9,101
Default 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?
Reply With QuoteReply With Quote