Is there a way to eliminate the Mail-Order rows
and save the Excel file to
just have the Internet order tracking numbers?

On a spare copy ..
try an autofilter for "MO" in col B
then delete all the "MO" rows,
then remove autofilter

Data assumed in cols A and B
Insert a new top header row
Click Data Filter Autofilter
Select "MO" from the droplist in B1
Select all the filtered rows (select the row headers)
Right click Delete Row
Remove autofilter

The remainder will be what you're after
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"DanJanowiak" wrote in message
...
Hello. I have a Excel file that contains a large list of Tracking
Numbers.

The tracking numbers are from two sets of order types- Internet orders and
Mail Orders.

Orders that are from the Internet are matched up with a order number such
as
"5678". Orders from the mail-order side are designated by initials "MO".

So in Excel it'll look something like this:

trackingnumber orderid

123365656666 5467
152155896345 5468
123365634567 MO
152134567789 5469
152151234563 MO

Is there a way to eliminate the Mail-Order rows and save the Excel file to
just have the Internet order tracking numbers?

Thanks for you help!