Need to run a simple command (=A2-A3) but only on 2 cells that come after a certain value

[lhasaoms]

Here is a basic scenario. I am looking at customer records and I want to find the number of days since their last and previous order.

Let's say column A has the following info:

1 Customer Name John
2 03/09/15
3 01/02/13
4 12/12/12
5 11/01/11
6 Customer Name Frank
7 03/09/15
8 01/02/13
9 12/12/12
10 11/01/11

So I would need to take the first 2 cells AFTER the cell the contains the value "customer" and subtract them to find the amount of days between the two. The sheet has thousands of lines. Thanks!

[Special-K]

in B1
=IF(LEFT(A1,8)="Customer",A2-A3,"")
and copy down

[lhasaoms]

AWESOME! Thanks. One last question. If the cell with the value "customer" has some other extraneous data in the cell can I just have your formula look for a cell containing "customer" instead of that exact left count? I appreciate it!

[lexusap]

Hi,

Try this

Please Login or Register  to view this content.

Cheers
Albert



Please don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).