I'm basically copying videos so my understanding of the intuition here is a bit lacking so bear with me.
In Cell F1 I have an array that finds the values that meet some criteria. The array results for instance are {0,0,0,0,1,1,0,0,1,0,1 etc....}
The test criteria that results in the above array is a really long string of inequalities comparing results to some fixed criteria. Anyway...
Here is the part of the spreadsheet I want to make more efficient:
In cells C15:K33 I have:
=(stufff)IF(*the entire cell contents of F1*, ROW(bla bla bla
I'm not great at working with arrays. Can I just reference the cell contents of F1 instead of copying the contents somehow? I'd like to make this more rubust and permanent.
In Cell F1 I have an array that finds the values that meet some criteria. The array results for instance are {0,0,0,0,1,1,0,0,1,0,1 etc....}
The test criteria that results in the above array is a really long string of inequalities comparing results to some fixed criteria. Anyway...
Here is the part of the spreadsheet I want to make more efficient:
In cells C15:K33 I have:
=(stufff)IF(*the entire cell contents of F1*, ROW(bla bla bla
I'm not great at working with arrays. Can I just reference the cell contents of F1 instead of copying the contents somehow? I'd like to make this more rubust and permanent.