# Displaying a Value Until a Certain Count is Reached

#### yoman219

##### New Member
Hi so I am trying to create a way so my column B displays a 0 until a certain count is reached, 64 rows. Currently I am using this in column B, =IF(\$C\$1<=\$D\$1,0," "). Where C1 is the count display, =COUNT(B:B), and D1 one is just the value, 64. The problem is that this is a circular path and I am not sure how else to do this. Also in column A I have an increasing time interval with the increment of 92 seconds. How would I be able to determine what the time is when the count is 64. I will be using this with a variable count and time increment so if there is a way where these were my only two inputs that would be awesome!

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce
I'm not quite sure what you're after, but it seems like you want to simply return the time at the "count"'s row.

And you can do that with:
Code:
``````= StartingTime + Time(0,0,92*count-1)

or if it's on a sheet

=A1+Time(0,0,92*\$D\$1-1)``````

I suppose a better way of explaining this would be. Each 0 is representing a person and the time next to them is there arrival time. I need a way so the 0's keep displaying in column B until the number of rows hits the count value of 64. Also I will have to abstract that time value of the 64th person to manipulate it else where. Unfortunately I have to use 0 to represent the person. If you still have questions I'd love to keep trying to explain too

Replies
2
Views
187
Replies
10
Views
346
Replies
8
Views
140
Replies
19
Views
815
Replies
2
Views
172

1,196,480
Messages
6,015,449
Members
441,895
Latest member
Zululander

### 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