Gerald
You must understand that no one who is reading what you wrote has any
idea about what you mean by the terms you use. Please post back and explain
what you have, what you want to have, and how you want to get from one to
the other, and do it all in plain common words. For instance, explain:
"empit 1"
"displayed as addition"
"displayed as deletion"
HTH Otto
"Gerald" wrote in message
...
dears,

I have a excelsheet with name excelsheet 3 with 5000 rows.
It has more or less same information i.e. 2 or 3 rows with empid 1 will
be
present though one hightligted in yellow and another highlighted in green

I am doing a comparision on column empid i.e. if empid 1 (red) is seen and
if no corresponding yellow then it has be displayed as additon or if empid
1
(yellow) is seen and if no corresponding red then it has be displayed as
deletion

would really appreciate any help on this

thanks