I have a database in an excel file that needs to be checked for integrity and some flags added to each entry according to some rules.
There are 121,000 records so you can not view on Excel 2003. Must use the new Excel if using windows.
I need some rules made that will categorize the records.
Some records have fields missing for example. Some records
are compared across fields with two datasets but differ slightly.
I need these flagged.
There are about ten rules or so .
This could be done manually but would take some days.
Either way I would like the flags for each record entered.
This job is simple for knowledgable computer experts.
DB File is around 7Mb