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
--

Mvg Warzel

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

Select all names, including headers. Name selection ArrayS.
Select equal size destination area and name it ArrayD.

Data | Filter | Advanced Filter | Copy to another location |
List range: ArrayS | Copy to: ArrayD | Unique records only | OK

Instead of | Copy to another location |, you can | Filter the list,
in-place |,
but this merely hides the duplicate rows.

Try this:
A2: =IF(SUMPRODUCT(--(A2&B2=$A$2:A2&$B$2:B2))1,"Duplicate","")
A3: copy down

Ola Sandstrom

Note:
The & joins the First&Lastname.
-- is a trick to turn True into 1 and False into 0, so they can be added.
The 2nd time a Names comes up will be called a duplicate due to the $A$2 and
$B$2. If it should be the opposite (the last name is the most current
address) 'fix' the last cell ($A$500$ and $B$500$) instead of the first cell
($A$2 and $B$2).

You can also use the formula in combination with Conditional formatting :
Formula is =... to highlight new duplicates as they are entered.