yes
--
Gary''s Student


"Danbmarine" wrote:

> thanks, will this also work if the target cell is not in the same row as the
> list that I am comparing it to?
>
> "Gary''s Student" wrote:
>
> > Use the MATCH() function. It will tell you both if its there and where it is.
> > --
> > Gary's Student
> >
> >
> > "Danbmarine" wrote:
> >
> > > I would like to see if one cell is equal to any other cell in an entire row.
> > > The row contains over 10,000 cells of data how can I insert a formula to do
> > > this?