Do math based on partial match to previous

[Closed]
Report
-
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
-
Hello,

I need to subtract column I, the previous row, from column I current row and output the result into column J. The issue I have is I need this done ONLY for rows where column D partially matches the first 5 characters from the previous row. Currently I have =(I3-I2) and formatted it down the column, but I am unsure how to make it only apply when there is that partial match. Thanks.

1 reply

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
use this formula
=left(I3,5)=left(I2,5).

if not got what you need than

please provide a sample of how your sheets look like or upload a sample of your workbook using a site like www.speedyshare.com. Also re-explain what you would like to see happen in more detail for better understanding.