Finding the position of data item in a list

[jk1]

Hello,

I'm trying to determine the position of an item in a data list depending on whether the item has been flagged or not. Hopefully the following should illustrate it a bit better.

Column A - Data Items
Apples
Pears
Bananas
Oranges

Column B - Included?
No
Yes
No
Yes

Column C (formula driven) - position of item in list
Blank cell
1
Blank cell
2

Any help greatly appreciated.

Thanks!

[Andy Pope]

Assuming your data is in the range A1:B5 use this in C2 and copy down

=IF(B2="Yes",COUNTIF($B$1:B2,"Yes"),"")

[jk1]

Thanks Andy!

Much appreciated :-)

[isadorasarah]

Thank you Andy. I also encountered a similar problem