excel help

[Hung]

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

 

[Fred Smith]

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

Regards,
Fred

 

[JLatham]

A couple of questions to help others with this problem:

Is there a particular sequence the Bs and Ps will appear in, such as always
a B or P in A1? Or is it all rather random?

Do you want the comparison based on all 100 cells, or do you want it done
row by row and then go back and figure out when count of Bs became greater
than count of Ps?