View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default formula for "does one cell equall another cell"

what is your criteria for acceptable and for wrong?
do you want Good ones to show or bad ones
???"...only entry in a formula that does not add up is the correct entry
...."???

"merricasigns" wrote:

I am trying to double check that all entries in a cell are correct. I have
added across and down. But checking across means looking at every entry for
more than 100 entries. I saw another person use a formula that checked across
and the only entry in a formula that does not add up is the correct entry
otherwise all the cells have a dash.