P
Phil Newman
OK, I now need to plot these values, but excel graph won't allow me
to
use INDIRECT.
I have column data like below.
1 0.35
2 0.46
3 0.46
4 0.48
5 0.48
6 0.95
7 0.89
8 0.66
9 0.65
I only want to use the data in ranges between 3 and 5 in column 1.
using INDIRECT I can to find the max/min between two specified numbers
(3 and 5)
D3 = 3
D4 = 5
=MAX(INDIRECT("B"&MATCH(D3,A1:A9)&":B"&MATCH(D4,A1:A9)))
I now want to plot both data between 3 (D3) and 5 (D4).
How can I do this?
Phil
to
use INDIRECT.
I have column data like below.
1 0.35
2 0.46
3 0.46
4 0.48
5 0.48
6 0.95
7 0.89
8 0.66
9 0.65
I only want to use the data in ranges between 3 and 5 in column 1.
using INDIRECT I can to find the max/min between two specified numbers
(3 and 5)
D3 = 3
D4 = 5
=MAX(INDIRECT("B"&MATCH(D3,A1:A9)&":B"&MATCH(D4,A1:A9)))
I now want to plot both data between 3 (D3) and 5 (D4).
How can I do this?
Phil