View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech
 
Posts: n/a
Default Range? Average.. Match.. Exact?

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...