ExcelBanter - Help to find duplicate #'s

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help to find duplicate #'s (https://www.excelbanter.com/excel-worksheet-functions/49338-help-find-duplicate-s.html)

SPENCER

Help to find duplicate #'s

Hi Can someone please help me. I am using Excel 2002 and I have about
3,000 #'s (example 4992-5) that I want to find out if any of them are
duplicates. What function would I perform to solve my problem? I
appreciate any help you could offer.

Many thanks,

Spencer

--
SPENCER

Dave Peterson

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

SPENCER wrote:

Hi Can someone please help me. I am using Excel 2002 and I have about
3,000 #'s (example 4992-5) that I want to find out if any of them are
duplicates. What function would I perform to solve my problem? I
appreciate any help you could offer.

Many thanks,

Spencer

--
SPENCER

--

Dave Peterson

All times are GMT +1. The time now is 06:04 AM.