Duplicate info in a database

V

vlada.cvetkovic

howdy,
I'm sorry if this has already been asked and answered but I can't seem
to find it.
I have a database with 5927 entries in each column with a total of 5
columns (A-E). I need to remove the duplicate information in the first
column (A) however the information is linked with figures in the other
4 columns. When I tried the advanced format feature I couldn't get it
to work properly (could sort column A but not have the linked data) is
there a simple way to do this or will I require a complex forumla?
Thanks a million
 
M

Max

Try this on a **spare** copy ..

Assume source data in cols A to E, from row2 down
with col A as the key col

Type a label in F1, eg: Dup
In F2: =IF(COUNTIF(A$2:A2,A2)>1,"x","")
Copy down to the last row of data in col A
This flags duplicates in col A with an "x"

Then just apply autofilter on col F, choose: x
Select the filtered rows (select the blue row headers),
right-click > Delete Row
Remove autofilter
 
Top