There are various times when it is useful to be able to compare the data in two or more separate records from the same table. For example when you have imported a change to a record, you should make a copy of it before you run your import which you can then use to compare with the same record after the import. Continue reading Comparing records in Excel
I spend my working life implementing Maconomy, BizView, and other ERP and data analysis systems, and I often have to clean and prepare data sets for importing to database tables. This nearly always involves constructing a clean data set in an Excel sheet – often from more than one source – and for this work there are a number of methods I use time and again. Continue reading Testing Equivalences in Excel
There are a few Excel cell formats that I use over and over again, but I never remember the exact syntax, so I put this page together primarily so I could look them up myself. I then added some other formats that I thought might be helpful to people just starting out in Excel.
#,###.00_);[Red](#,###.00);-_);[Red]"Invalid – numbers only "@ Continue reading Useful Custom Cell Formats