ExcelBanter - check a list of numbers for duplicate entries in Excel

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - check a list of numbers for duplicate entries in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/104804-check-list-numbers-duplicate-entries-excel.html)

Space

check a list of numbers for duplicate entries in Excel

Max

check a list of numbers for duplicate entries in Excel

"Space" wrote:
check a list of numbers for duplicate entries in Excel

Assuming source numbers running in A2 down

Put in B2:
=IF(A2="","",IF(COUNTIF($A$2:A2,A2)1,"Dup",""))
Copy down

Col B will flag duplicates in col A as "Dup"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Space

check a list of numbers for duplicate entries in Excel

Thanks that works altough my pc hung a couple of time due to size of file
hence tardy response!
"Max" wrote:

"Space" wrote:
check a list of numbers for duplicate entries in Excel

Assuming source numbers running in A2 down

Put in B2:
=IF(A2="","",IF(COUNTIF($A$2:A2,A2)1,"Dup",""))
Copy down

Col B will flag duplicates in col A as "Dup"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max

check a list of numbers for duplicate entries in Excel

Glad it worked out ok!
Thanks for calling back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Space" wrote:
Thanks that works altough my pc hung a couple of time due to size of file
hence tardy response!

All times are GMT +1. The time now is 08:25 PM.