Data Retrieval

[Steve 1962]

Hi

Need some help with a formula -

In cell D1 a value is set that controls the values in column D. If the value in column C is less than that in cell D1, then the first three values that align with 1,2,3 in column B will be displayed in column D in the corresponding row. However, if the value in column C exceeds that value in cell D1 then the first three values are blank. I have done this manually but can't get a formula to do it (please no VBA).

Thanks

Steve

Book1
	A	B	C	D
1				7.00
2
3	Data	Sequence	Parameter	Time
4	8.75	1	6.17	8.75
5	6.83	2		6.83
6	6.88	3		6.88
7	7.07	4		7.07
8	7.50	5		7.50
9	6.80	6		6.80
10	2.30	7		2.30
11	5.80	8		5.80
12	7.75	9		7.75
13	7.70	10		7.70
14	8.23	11		8.23
15	11.18	12		11.18
16	11.25	13		11.25
17	11.07	1	10.00
18	8.18	2
19	8.73	3
20	9.08	4		9.08
21	10.00	5		10.00
22	10.48	6		10.48
23	10.95	7		10.95
24	10.53	8		10.53
25	11.58	9		11.58
26	10.58	1	27.37
27	10.08	2
28	9.75	3
29	10.08	4		10.08
30	10.53	5		10.53
Sheet1

 

[Andrew Fergus]

Hi

Assuming you don't ever have a run/sequence less than 3, and a new sequence always starts with a new value in column C, then the following formula in D4 (copied down) might do the trick:

=IF(SUM(C2:C4)<$D$1,A4,"")

If my assumptions are not correct, then the formula will need to be changed.

Andrew

 

[Steve 1962]

Hi Andrew

Thanks very much. Works just the way I want.

All the best and keep up the good work.

Steve