Failing HARD at Excel Thing - Removing Duplicates Based On Single Column

[Miscbrah]

Ok here goes, tearing my hair out over this one.

 

So, I export a list of students from SIMS. Basically what I'm trying to do is get a report together of just one single parent/guardian email address per student.

 

List in vanilla form looks something like:

 

 

And what I'd like to have is for every kid in the first column, just the one entry (so I only get that single parent/guardian email address per student.) So something like:

 

 

Trying I guess to de-duplicate the whole thing based on the first column, but I'm really not succeeding.

 

Can anyone with some clevers that way help me out? Thanks much in advance.

[NegativeKillDeath]

The Data tab in excel has a Delete duplicates button. Select the range, click the button and then chose which column(s) you want to find duplicates.

[andy_b]

Highlight table, remove duplicates from data toolbar, make sure only column A is ticked ? Edited February 6, 2024 by andy_b

[sigma]

You could use Macros, or for a quick and dirty, Sort and Filter - "custom sort".

 

Assuming there is only one parent one per pupil:

Sort by:

Parent Name

Student.

 

Block delete everything after the last parent one entry.

[Steve21]

Can anyone with some clevers that way help me out? Thanks much in advance.

 

Any reason you just don't use the don't show duplicates option in the SIMs report? Should remove it from showing two lines per student and only output 1 assuming you're focus is students

 

Steve

[Miscbrah]

The Data tab in excel has a Delete duplicates button. Select the range, click the button and then chose which column(s) you want to find duplicates.

 

You know I tried this yesterday and for some reason it was doing something bananas. Think it's probably something to do with having filtered out empty entries in the parent email addresses before running it (so we'd only ultimately be showing things with data in there, and if a blank field appeared there it'd be gone.)

 

This morning re-read all this and though I'd get a bit rough with it, so copied that filtered data out into a new document THEN ran the de-dupe against the first column and it worked fine. This was KILLING me yesterday as well.

 

Thanks everybody for all the help there.