#### questionexcel

##### New Member
I'm trying to find the date in which my customers reached 70% interest in our product during the 10 day trial period. To do this, I marked "1" for the days in which the customer opened our product and "0" for the days in which the customer did not open our product. Because my data file is quite large, I want to be able to just drag one formula down and get the date.

For example:
Out of the 10 day trial period, Jack used our product for 7/10 days. We want to know the date in which Jack reached 70% interest (rounded up).

 Date 1/1/15 1/2/15 1/3/15 1/4/15 1/5/15 1/6/15 1/7/15 1/8/15 1/9/15 1/10/15 70% Jack 1 0 1 1 1 0 0 1 1 1 =MATCH((ROUNDUP(0.7*(COUNTIF(B2:K2,1)),0)),B7:K7) Jill 1 0 0 0 1 1 1 0 1 0 Amy 1 0 1 1 1 1 0 0 0 1

<tbody>
</tbody>

The formula that I've made (in red below) returned the value of 8, which tells me that the 70% interest occurred on the 8th day.

=MATCH((ROUNDUP(0.7*(COUNTIF(B2:K2,1)),0)),B7:K7)

Would anyone happen to know how I could change the formula to make the formula return the value of 1/8/15 (the date in which the 70% interest occurred) instead of the number 8?

Also, I'm new with excel so I'm not sure if the logic behind this formula makes sense, so please let me know if there's a better way to approach this.

Last edited by a moderator:

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
What is contained in the range B7:K7? It does not appear in your post.

Replies
3
Views
180
Replies
1
Views
598
Replies
15
Views
506
Replies
3
Views
2K
Replies
4
Views
538

1,196,484
Messages
6,015,469
Members
441,898
Latest member
kofafa

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