Dave
I tried the following formula in a test worksheet using one column named
Range with same data as displayed on the website

=IF(MAX(COUNTIF(Range1,Range1))1,"Duplicates","No Duplicates")

Then I pressed CTRL+Shift+Enter
I get the following result
#NAME?

Any ideas what I am doing wrong?
Much appreciate your help

"Dave Peterson" wrote:

What formula did you use?

Where's your data?

I've never had trouble with the formulas.

Julie Melbourne wrote:

Thanks Dave
I have looked at this site, but cannot get the formula to work?
Must be doing something wrong. Have you tried it?
Do you have a working spreadsheet wtih this formula?

Thanks for you help
Julie Melbourne

"Dave Peterson" wrote:

You may want to read some of Chip Pearson's techniques for dealing with
duplicates:
http://www.cpearson.com/excel/duplicat.htm

Julie Melbourne wrote:

How do I deduplicate data in Excel. I have a large database of names and
addresses which I want to check to duplication

--

Dave Peterson


--

Dave Peterson