Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Excel Duplicate Search

Posted on 2014-04-15
2
Medium Priority
?
129 Views
Last Modified: 2014-04-15
I have a spread sheet with 14k entries containing first name, last name, city, and email address.  I want to flag duplicates.  My thought was to place an "x" in column E next to all duplicate entries.  I am having trouble with the formula.  Any help would be much appreciaed.
0
Comment
Question by:Bob Schneider
2 Comments
 
LVL 54

Accepted Solution

by:
Rgonzo1971 earned 2000 total points
ID: 40001282
Hi,

you could use

=IF(COUNTIFS(A:A,A1,B:B,B1,C:C,C1,D:D,D1)>1,"X","")

Open in new window


Regards
0
 

Author Closing Comment

by:Bob Schneider
ID: 40001287
Thank you
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question