Is it possible to return only 1 specific column using the filter function? I have seen the methods of choosing adjacent columns, but I would like to return only 1 specific column.
For example, I have used the formula =(FILTER(A2:B28,(A2:A28>=I2)*(A2:A28<=J2),"NA")) which returns the below data
Would it be possible to have it only return the "Hi Temp" column?
The full worksheet is below. Many thanks.
For example, I have used the formula =(FILTER(A2:B28,(A2:A28>=I2)*(A2:A28<=J2),"NA")) which returns the below data
Would it be possible to have it only return the "Hi Temp" column?
The full worksheet is below. Many thanks.