Incremental comparison
This might be a start (see enclosed): Sheet1: Column A is numbered cells Sheet2: A2: =CHOOSE(1+(B2="Row "&ROW()&" added")*1+(B2="Row "&ROW()&" deleted")*2;A1;A1-1;A1+1) B2: =CHOOSE(1+(ROW()+A1INDIRECT("Sheet4!A"&ROW()))*1+ (ROW()+A1<INDIRECT("Sheet4!A"&ROW()))*2;"";"Row "&ROW()&" added";"Row "&ROW()&" deleted") Hope it helped Ola Sandström +-------------------------------------------------------------------+ |Filename: Book4.zip | |Download: http://www.excelforum.com/attachment.php?postid=3480 | +-------------------------------------------------------------------+ -- olasa ------------------------------------------------------------------------ olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760 View this thread: http://www.excelforum.com/showthread...hreadid=378229 |
All times are GMT +1. The time now is 10:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com