You could mark the duplicates, then delete the marked rows. Try the
following on a copy of your workbook:

In a blank column, in the first row with data, enter a formula that
compares the two columns to previous entries, e.g.:

=IF(SUMPRODUCT(--($A$1:A2=A2),--($B$1:B2=B2))1,1,"")

Copy the formula down to the last row of data
Select the column with the formula
Choose EditGo to
Click the Special button
Choose Formulas, and clear all the check boxes except Numbers
Click OK

Choose EditDelete
Select Entire Row
Click OK


Warzel wrote:
I want to remove duplicates from a sheet testing for values in two coloms

in the first colom are hunderds of firstnames
in the second colom hunderds of lastnames

What i want is to remove duplicates when both first and last name in a
row are equal


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html