Hi!

Here's one way:

Assume your data is in the range A1:Q5400

Select column A and insert a new column.

In A1 enter this formula:

=COUNTIF(B$1:B$5400,B1)1

Copy down to A5400. If there are no blank cells within the column B range,
B1:B5400, you can just double click the fill handle for quick copying of the
formula. (beats the heck out of dragging!)

With the range A1:A5400 still selected goto EditCopy. Then EditPaste
SpecialValues.

Now, hit function key F5 and enter the range A1:Q5400. OK

Now goto DataSort

Sort the range on column A descending.

Any duplicates will have a value of TRUE in column A and all of the TRUE's
will now be at the top of the range.

You can either delete all the rows that show FALSE or copy all the rows that
show TRUE to another location.

Biff

"Daniell" wrote in message
...
I have a spreadsheet that has 15 columns and about 5400 rows. Column A has
the part number. Is there a function or macro that can run though the
spreadsheet and keep the whole row based on the fact that there are
duplicate
part numbers in column A and delete the rows that are not duplicate. All
I
want to see are the complete rows of all duplicate rows.

Thanks in advance.