Range? M1:Z1
 

Hi, can not remember how to see if 1 cell, is equal to same quantity in range
of other cells. Tried / to find: (thanks)

=F1=M1:Z1 getting ref error

Range? M1:Z1
 

You could use match, which with 0 as the last argument will return NA if the
match fails:
=if(isna(match(f1,m1:z1,0)),"Not found","found")

"nastech" wrote:

Hi, can not remember how to see if 1 cell, is equal to same quantity in range
of other cells. Tried / to find: (thanks)

=F1=M1:Z1 getting ref error

Range? M1:Z1
 

is it

=IF(F1=SUM(M1:Z1),"yes","no")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"nastech" wrote in message
...
Hi, can not remember how to see if 1 cell, is equal to same quantity in
range
of other cells. Tried / to find: (thanks)

=F1=M1:Z1 getting ref error

Range? M1:Z1
 

if dd in f4 and dd anywhere in col d, deal

=IF(COUNTIF(D:D,F4)0,"deal","no deal")

--
Don Guillett
SalesAid Software

"nastech" wrote in message
...
Hi, can not remember how to see if 1 cell, is equal to same quantity in
range
of other cells. Tried / to find: (thanks)

=F1=M1:Z1 getting ref error

Range? M1:Z1
 

That was it... / will try, thanks all

"nastech" wrote:

Hi, can not remember how to see if 1 cell, is equal to same quantity in range
of other cells. Tried / to find: (thanks)

=F1=M1:Z1 getting ref error