I have data that exports out of a Govt database into Excel. The problem is that it exports a complete record for each person for each time they have a vaccination in a set of 3. So if they have had Vaccination 1 and 2 you get two duplicate row records except for the Vaccination column. This includes everything duplicated address etc. I need to build a mail list of those who have had only one vac, or 1 and 2. I have tried all sorts of ways using filtering, autofiltering etc. Can any one help.
e.g.
First Name Last Name Vaccinations
John Bell 1
John Bell 2
John Bell 3
Mary Smith 1
Mary Smith 2
In the end I just want one record for each of those who have not had shot 3 and another list which shows each of those who have not had 2 or 3.
I cannot change the database and have to work with how I get it in Excel.
e.g.
First Name Last Name Vaccinations
John Bell 1
John Bell 2
John Bell 3
Mary Smith 1
Mary Smith 2
In the end I just want one record for each of those who have not had shot 3 and another list which shows each of those who have not had 2 or 3.
I cannot change the database and have to work with how I get it in Excel.