Don't know what "start" is, but try this in C1:

=IF(B2<start,0,IF(B2=B1,"Remove",0))

Hope this helps.

Pete

On Jul 29, 12:28*pm, TFMR wrote:
Dear All,

I want the following formula:-

First the formula check wether B2 = Start if no then 0 if yes then check
wether B2=B1 if no then 0 otherwise C1 = "Remove"

Thanks & Regards