Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Range Names by worksheet | Excel Discussion (Misc queries) | |||
Help with using range names in sum function | Excel Worksheet Functions | |||
How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
Can a formula check for a certain value in a range? | Excel Discussion (Misc queries) | |||
can a formula check for a certain value in a range? | Excel Discussion (Misc queries) |