weed out like items

[chapm4]

Hi,
I have a worksheet that has student names, classes, and id. ID is listed mu
ltiple times (because of multiple classes that one student takes). I want t
o break down and have each students name and id only once on a seperate work
sheet. Can someone help me do this?

Current Example:
12345678 Smith, Joe Algebra
12345678 Smith, Joe Math
12345678 Smith, Joe English
23456789 Smith, Tom Reading
23456789 Smith, Tom Algebra

Want:
12345678 Smith, Joe
23456789 Smith, Tom

[barrfly]

there are several ways to single out only one unique record in a series of records that have many duplicates. one would be to sort the list and then count do an if then statement..but I prefer a quick trick.

Select the column that has the student ID. On the Toolbar choose data-> filter->advanced filter.

Make sure the list range is correct (the column with the student IDS)

Check the "Unique Records" box and select ok.