I'm not sure I phrased this title correctly. Please feel welcome to offer suggested edits.
I have data formatted like so:
Token,Location,Quantity VBD,IN,100 NN,IN,200 FD,OUT,300 VBD,OUT,300 NN,OUT,400 NN,IN,100
Ultimately, I would like to perform t-tests on the Quantity of each Token, comparing IN and OUT. Is there a way to do this without filtering for each, and performing a t-test?
The t-test part isn't relevant, per se, I'm just looking to insert a range into a formula. The =TTEST function, for example, takes the following arguments:
TTEST(array1,array2,tails,type). If I wanted rows 2 and 6 in
Array1 (NN,IN), and row 5 in
Array2, is there a formula I use within the
TTEST formula, in lieu of selecting the cells?