Is this what you want:
=if(countif(A1:A100,"B")countif(A1:A100,"P"),"W", "")
?

Regards,
Fred

"Hung" wrote in message
...
I need help to write this function. In my table I have one column A1:A100,
in each row it could have one text, could be "B" or "P", I want to compare
from A1 down to A100 if "B" is more than "P" by one then stop the
comparation
and display a "W" in next column at the row.

Thanks

Hung