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