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