Checking for errors

  • Thread starter Thread starter Daniel
  • Start date Start date
D

Daniel

I need to check that data entered into a document is correct,
I have loaded a spreadsheet from the text file and saved it as a xls file.
Column B and D are supposed to show the same data
but errors have been made, is there some way to have Excel compare column B
with D and indicate rows where B and D do not match?

thanks

Daniel
 
If you put +b1=d1 in cell e1 ( or whatever cell is free )
you'll see TRUE if they are the same, or FALSE if not -
 
Back
Top