Alacrify Ltd

Useful Excel Worksheet Comparison

Published on: 18th January 2010
By Alacrify



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", "-")


 

 

New Website For Osmington Village Hall

We’re pleased to announce that we have just launched a NEW website for Osmington Village Hall. Osmington Village Hall came to us needing a brand new website as the old one had been taken offline. We built the website from the ground up taking a fresh new approach alongside Osmington Village Hall.

Relaunch Of Weymouth And Portland Info Website

We’re excited to announce that we have relaunched the Weymouth and Portland Information website. The website is an internal project of ours and one that’s needed attention for a while. The main aim of the redesign was to make the website responsive and easier for users to navigate around.

New Website For R-em Therapies

We have just launched a new website for Emma at R-EM Therapies. R-EM Therapies is a new client of Alacrify’s that we’ve thoroughly enjoyed working with. R-EM came to us needing a new website as the old site was starting to show its age. The old site also wasn’t responsive and was also unsecure which negatively impacted the site's search engine rankings as well as being hard for users to access on their mobiles and tablets.

New Website For Ecs Special Projects

We have just launched a new website for ECS Special Projects. This is another website of ours that we originally built many years ago. The old site stood the test of time and still performed very well in Google searches, but the time had come for the look and feel to be updated in line with more contemporary design approaches.