Range? Average.. Match.. Exact?

N

nastech

Hi, don't know what to use:

Need an equation that tests range of cells, to have exact same number in
another cell, thanks

something like IF(A1=AVERAGE(B1:E1) but need exact match...
 
B

Bob Phillips

What is wrong with the formula you have, assuming you complete it?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top