Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF with compound comparison | Excel Worksheet Functions | |||
Comparison of data between three spreadsheets | Excel Worksheet Functions | |||
How do I paste several files together for comparison? | Excel Discussion (Misc queries) | |||
Comparison Function | Excel Worksheet Functions | |||
How to apply conditional formatting with incremental address for . | Excel Worksheet Functions |