How to flag a series of selections based on the order of the selection?

[stuckagain22]

Here's an example:

Rows A1 to A10 will flag as "yes" if a condition is met on the appropriate row in another column.

When the first "yes" appears, I want to rank it as #1. When the next "yes" appears, I want to rank that as #2, and etc. Is there anyway to do this? (Preferably with cell formulas).

Thanks.

 

[konew1]

Try this in A2 and copy down
=IF(B2=2,"yes "&TEXT(COUNTIF($A$1:A1,"yes*")+1,0),"")

My reference to B2 is the condition in the other column

 

[stuckagain22]

Unfortunately this doesn't work as it "serially" numbers the selections.

If A3 is triggered first, it will show "1" in A3.
If A5 is triggered next, then it will show "1" in A3 and "2" in A5.

Now, here's the problem...

If A4 is triggered next, then it will show "2" in A4, and A5 will now change to "3".

I'm beginning to think the only way to make it work will likely be something in vb code... which I don't know at all.