Creating a Flag based on cell value

You shouldn't need a UDF for that. Try this formula and drag down:

=IF(MOD(SUM(($A$5:A5="Key")*1),2)=1,"Yes","No")

It is an array formula so be sure to use ctrl shift enter.

in cell Y1
=MOD(COUNTIF($X$1:X1,"Key"),2)

then drag fill down the column

would also work.

--
Regards,
Tom Ogilvy

"Brian Taylor" wrote:

> You shouldn't need a UDF for that. Try this formula and drag down:
>
> =IF(MOD(SUM(($A$5:A5="Key")*1),2)=1,"Yes","No")
>
> It is an array formula so be sure to use ctrl shift enter.
>
>

I've been out done! Nicely done Tom. I guess I get stuck on array
formulas sometimes. Better to avoid them if you can.