@ 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