View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Chunka Chunka is offline
external usenet poster
 
Posts: 4
Default How do I find duplicate entries in a column in an Excel worksh

Thank you so much JLATHAM, you rock! This helped a lot. FYI, the formula as
written shows "duplicated" if the line above it is a duplicate, so if the
duplicate records are not consecutive it would not work. I changed the "A1"
reference to "A2" so that it would display "duplicated" only if that
particular line was a duplicate record!

"JLatham" wrote:

In column C, or another available column, put a formula like this in the
first row with values in A to be examined, then fill the formula on down the
sheet to the end of the list:
=IF(COUNTIF(A$1:A$7,A1)1,"Duplicated","")
Change A$1:A$7 to include your whole range in column a, as perhaps A$2:A$1504

If you can put that in column C, and if there are entries all the way down
the sheet in column B, then you can quickly fill it by moving the cursor to
the lower right corner of the cell with the formula in it until it becomes a
thick + symbol instead of the normal fat cross, then double-click the left
mouse button to fill it all the way to the end.

"Chunka" wrote:

I am working with Excel 2000. I have two columns. Column A contains a
Procedure number and column B contains the associated fee. Each procedure
should only be represented once. My goal is to identify instances where a
procedure is repeated (duplicate entries), so that I can determine which
entry is correct. If you are familiar with Access, I am basically trying to
achieve in Excel, the same thing that a "Find Duplicates" query does in
Access.