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
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
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
is it
=IF(F1=SUM(M1:Z1),"yes","no")
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
"nastech" <[email protected]> wrote in message
news:[email protected]...
> 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
if dd in f4 and dd anywhere in col d, deal
=IF(COUNTIF(D:D,F4)>0,"deal","no deal")
--
Don Guillett
SalesAid Software
[email protected]
"nastech" <[email protected]> wrote in message
news:[email protected]...
> 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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks