crash_override
New Member
- Joined
- Jul 2, 2014
- Messages
- 6
I have three columns of information and I want to talk the STDEV of a certain range of data in the third column based on information in the first.
So based on whatever I put into columns A-C, E1 and F1 will change to give the first and last values in column 1 that I am interested in - these are the same bounds that i am interested in analyzing in column C. So in this case I have determined that my bounds are row 2 to row 4, I only want to analyze data in rows 2, 3, and 4. So now I want to take the STDEV(C2:C4) based on what comes up in E1 and F1. Is this possible using the ADDRESS function or another similar function?
So far I tried using STDEV(ADDRESS(MATCH(E1,A:A,0),3):ADDRESS(MATCH(F1,A:A,0),3)) but this does not work.
<tbody>
</tbody>
So based on whatever I put into columns A-C, E1 and F1 will change to give the first and last values in column 1 that I am interested in - these are the same bounds that i am interested in analyzing in column C. So in this case I have determined that my bounds are row 2 to row 4, I only want to analyze data in rows 2, 3, and 4. So now I want to take the STDEV(C2:C4) based on what comes up in E1 and F1. Is this possible using the ADDRESS function or another similar function?
So far I tried using STDEV(ADDRESS(MATCH(E1,A:A,0),3):ADDRESS(MATCH(F1,A:A,0),3)) but this does not work.
A | B | C | D | E | F |
1 | 5 | 3 | 2 | 5 | |
2 | 7 | 4 | |||
4 | 9 | 3 | |||
5 | 10 | 5 | |||
6 | 11 | 3 |
<tbody>
</tbody>