Previous Topic Next Topic

Do math based on partial match to previous

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

Answer 1 / 1
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Apr 5, 2011 at 02:21 AM
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.
0