You can do that without disturbing your data using Filters
Filter Unique Records (Debra Dalgleish)
http://www.contextures.com/xladvfilter01.html#FilterUR
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Lynn Bales" wrote in message ...
I have 4000 rows of data that looks like this:

Number Status
C02504 Removed
C02504 Removed
C02504 Removed
C02504 Removed
C02504 Removed
C02504 Removed
c02536 Removed
c02536 Added
c02536 Added
c02536 Not Changed
c02536 Not Changed
c02536 Not Changed
c02536 Not Changed
c02536 Not Changed
C02564 Not Changed
C03869 Removed
C03869 Added
C03869 Added

What I need to accomplish is to eliminate all but one row where the number
and status are the same but keep ALL the rows where the number has several
different statuses. So basically I need the above to look like:

Number Status
C02504 Removed
c02536 Removed
c02536 Added
c02536 Added
c02536 Not Changed
C02564 Not Changed
C03869 Removed
C03869 Added
C03869 Added