@ Mama you formula is cool .......

@Rick your formula is short but will not return 1 or 0 until & unless
you will use negation ....

=--(OR($A$1=A2:D2))
press Ctrl+Shift+Enter (CSE)



Teethless mama;352666 Wrote: [color=blue]
This one doesn't required "array-entered"

=--OR(INDEX(A2:D2=$A$1,))


"Rick Rothstein" wrote:

While I would go with the COUNTIF method already posted, I just
thought it
interesting that this simple array-entered** formula works also...

=OR($A$1=A2:D2)

**Commit formula using Ctrl+Shift+Enter, not just Enter by itself.

--
Rick (MVP - Excel)




--
mubashir aziz

If this post helps Don't 4get to click Yes
------------------------------------------------------------------------
mubashir aziz's Profile: http://www.thecodecage.com/forumz/member.php?userid=237
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=98697