Do math based on partial match to previous

Closed
matttrick - 4 Apr 2011 à 10:13
RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 - 5 Apr 2011 à 02:21
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.

Related:

1 response

RWomanizer Posts 365 Registration date Monday 7 February 2011 Status Contributor Last seen 30 September 2013 120
5 Apr 2011 à 02:21
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.