If you want remove to appear in C1, then the formula goes in C1. Without
using VBA, you can't have data populate a completely different cell based on
a separate cell (without it's own formula).
--
John C


"TFMR" wrote:

Thanks its working.

If I put formula in C2 and "Remove" returns in C1

"John C" wrote:

Shorter formula:

=IF(AND(B2=start,B2=B1),"Remove",0)
--
John C


"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