# Data Retrieval

#### Steve 1962

##### Active Member
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
ABCD
17.00
2
3DataSequenceParameterTime
48.7516.178.75
56.8326.83
66.8836.88
77.0747.07
87.5057.50
96.8066.80
102.3072.30
115.8085.80
127.7597.75
137.70107.70
148.23118.23
1511.181211.18
1611.251311.25
1711.07110.00
188.182
198.733
209.0849.08
2110.00510.00
2210.48610.48
2310.95710.95
2410.53810.53
2511.58911.58
2610.58127.37
2710.082
289.753
2910.08410.08
3010.53510.53
Sheet1

### Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN
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

Hi Andrew

Thanks very much. Works just the way I want.

All the best and keep up the good work.

Steve

Replies
9
Views
566
Replies
3
Views
109
Replies
2
Views
105
Replies
7
Views
117
Replies
0
Views
203

1,203,758
Messages
6,057,184
Members
444,913
Latest member
ILGSE

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back