View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
ncrdbl ncrdbl is offline
external usenet poster
 
Posts: 1
Default How do I find duplicate entries in a column in an Excel worksheet?

I fond this very useful, I needed to create a list of Students with their
parent's name listed once. The raw list had the parent's name listed with
each of their kids, I used the formula to clear the parent's name on their
subsequent children.

Thanks again!

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