Useful Excel Worksheet Comparison
One of our current projects involves comparing multiple datasets from a csv database extract to show which records have been removed or updated. To do this there is an original worksheet that gives the default baseline data on a given date. Then a second worksheet is copied into this file for comparison. This happens on a weekly reporting cycle.
I hunted for a method to find any original records that had been deleted in the weekly report. I found a great little tutorial that did the trick on the Microsoft website:
http://office.microsoft.com/en-us/excel/HA011039151033.aspx
By looking up a matching value for each original primary id record in the weekly report the finished excel worksheet now shows the original records that are now "missing". It's a very helpful solution to a little tricky problem without resorting to a load of database coding.
This is the sort of formula I ended up with
=IF(ISNA(MATCH(A2,'report-26.01.10'! $B $2: $B $46,FALSE)),"Missing", "-")
Published:
Comments
Add your own comment to this story.Other Related Stories from Alacrify
CSS3 and Website Statistics Charts
The best methods for presenting site stats depend completely on working out what the client needs.
This month we&... Read More - published
Feedback for Dorset Art Weeks 2006
We have been commissioned to deal with the feedback forms for Dorset Art Weeks following our success with handling the d... Read More - published
Ordering Employers on Facebook
As I run, or am involved in, several business at the moment I wanted to put them all onto Facebook; however I also wa... Read More - published
Great Response to Maiden Newton Website
Since we launched the new village website for Maiden Newton we have had a great response from villagers and visitors ... Read More - published
Using .htaccess to Redirect Pages with $_GET Variables to Friendly URLs
As part of the recent changes to the OSE Directory website we changed the url structure that was used for the pages.
... Read More - published
Alacrify Ltd. 01300 320076. jon@alacrify.co.uk
