formula for "does one cell equall another cell"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
...."???
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Testing a cell value for a specific weekday. 3
drag formula down from columns that go acros 3
Copy corresponding cell in Column B if cell in A contains certain text? 1
Using "Verifiers" 2
my formated column is displaying one cell incorrectly 2
data validation across multiple columns 1
=AND($B$12<>"",$B$12<TODAY()+60) What does the <> mean in this? 3
Multiple array formula using 'does not equal 3

Back
Top