Capture.jpg

Hi everyone,

I have the spreadsheet set up as shown in the uploaded photo. What i am trying to achieve is to create an array in cells F3 & G3 that will return the values in column B if columns C & D is >= 1, respectively.

What you currently see in columns F & G if just a simple if function (if(C3>=1,B3,"")), however i cannot have blank cells and i cannot have zeros or anyother values aside from the values you see in column B. The reason for this is because i am using the t-test for two means as you can see on the right hand side and the data has to be arranged as the following:

Capture2.JPG