Value/IsNumber/Brackets..? cell equal to range w/o Average
 

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={"aa","ab",ac"})
as a normal equation, that functions properly

Value/IsNumber/Brackets..? cell equal to range w/o Average
 

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

"nastech" wrote:

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={"aa","ab",ac"})
as a normal equation, that functions properly

Value/IsNumber/Brackets..? cell equal to range w/o Average
 

=EXACT thanks :)

"bpeltzer" wrote:

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

"nastech" wrote:

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={"aa","ab",ac"})
as a normal equation, that functions properly