software

Hi, is there a way to check if a single cell is EXACT equal to each cell, in
a range of cells without listing each one separately? i.e.: (without using
average)

instead of =AND(C1=D1,C1=E1,...C1=AA1) maybe something like:

=(C1=D1:AA1) (EXACT/VALUE/ISNUMBER/brackets/quote marks..??)

note: have been able to use: =OR(C1={quot;aaquot;,quot;abquot;,acquot;})
as a normal equation, that functions properly

If I understand correctly, try =(countif(range,value)=counta(range))
In your particular example, =(countif(d1:aa1,c1)=counta(d1:aa1))

quot;nastechquot; wrote:

gt; Hi, is there a way to check if a single cell is EXACT equal to each cell, in
gt; a range of cells without listing each one separately? i.e.: (without using
gt; average)
gt;
gt; instead of =AND(C1=D1,C1=E1,...C1=AA1) maybe something like:
gt;
gt; =(C1=D1:AA1) (EXACT/VALUE/ISNUMBER/brackets/quote marks..??)
gt;
gt; note: have been able to use: =OR(C1={quot;aaquot;,quot;abquot;,acquot;})
gt; as a normal equation, that functions properly

=EXACT thanks

quot;bpeltzerquot; wrote:

gt; If I understand correctly, try =(countif(range,value)=counta(range))
gt; In your particular example, =(countif(d1:aa1,c1)=counta(d1:aa1))
gt;
gt; quot;nastechquot; wrote:
gt;
gt; gt; Hi, is there a way to check if a single cell is EXACT equal to each cell, in
gt; gt; a range of cells without listing each one separately? i.e.: (without using
gt; gt; average)
gt; gt;
gt; gt; instead of =AND(C1=D1,C1=E1,...C1=AA1) maybe something like:
gt; gt;
gt; gt; =(C1=D1:AA1) (EXACT/VALUE/ISNUMBER/brackets/quote marks..??)
gt; gt;
gt; gt; note: have been able to use: =OR(C1={quot;aaquot;,quot;abquot;,acquot;})
gt; gt; as a normal equation, that functions properly