ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   To find errors (https://www.excelbanter.com/new-users-excel/50388-find-errors.html)

Kalevi

To find errors
 
Hi
Is there a way to compare to similar files to make sure there are no errors
in the text or numbers. They are not copies of each other and are filled by
different persons.
Thanks
Kalevi



gls858

Kalevi wrote:
Hi
Is there a way to compare to similar files to make sure there are no errors
in the text or numbers. They are not copies of each other and are filled by
different persons.
Thanks
Kalevi


Compare them to what? Each other? If they're not the same how can a compare
tell you if they are correct or not. A better method might be to use
data validation and prevent any mis entries right in the beginning. Or
are you looking for duplicates on between the two sheets. Give us more
info. Help us, help you.

gls858



All times are GMT +1. The time now is 04:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com