From: Debra on
Will this same process work for three columns of data, not necessarily
concurrent. I want to ID duplicates where data in A, B and C are all the
same? If so can you help me with the detailed formula to write?



"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.
Pages: 1
Prev: Drop down list
Next: Search Capability