I'm not too sure if Excel is the best thing to do this in but I thought I'd ask anyway.
What I've got is a spreadsheet of raw data. In one field I have a unique identifier of a person, in the next field I have some codes which refer to the course of immunisations they have had and then there's another field which shows the area in which they live in. It looks something like this: PERSON IMMSCODE AREA Person1 65a0 Area1 Person1 65a1 Area1 Person1 65a2 Area1 Person2 65a0 Area3 Person2 65a2 Area3 Whats important here is that I am only interested in those people that have had ALL THREE codes (65a0, 65a1 and 65a2). Any that have only one or two codes are not to be included. Then for those that have all three codes I need to work out how many of them are in each area. I did try doing a subtotal on each change of person ID and then group by the immscode and then manually 'eyeball' any personIDs that had a count of 3 but as I'm looking at over 200,000 records its not ideal. Any ideas? Would Access be better? Even then I don't know what sort of SQL commands would do this sort of 'cleaning' Thanks, Sarah -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
