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
|