finding duplicate values....

[imported_unknown]

Hi,
I would like to be able to find duplicate values in a column. The first column of my spreadsheet contains id's (numbers only)
thanks!

 

[Yogi Anand]

On 2002-10-04 11:13, rosemaryp wrote:
Hi,
I would like to be able to find duplicate values in a column. The first column of my spreadsheet contains id's (numbers only)
thanks!

Hi rosemaryp:

Welcome to the Board!

You can use the COUNTIF function to locate the duplicates. see the worksheet simulation ...

y021004.xls
	A	B	C	D
4	IDNumber		Duplicate
5	101		No
6	102		No
7	102		Yes
8	103		No
9	104		No
10	105		No
11	105		Yes
12	102		Yes
13	107		No
Sheet3

</SPAN>

Regards!

Yogi

 

[Yogi Anand]

And ... if you want to locate what the duplicated entries are, and/or how many times an entry has been duplicated ...

you can use the ADVANCED FILTER and the COUNTIF formula, as presented in the simulation

y021004.xls
	A	B	C	D	E	F
1
2
3
4	IDNumber		IDNumber		NumberOfTimes Duplicated
5	101		102		3
6	102		105		2
7	102		102		3
8	103
9	104
10	105				sourcedata
11	105				criteriaforFilter
12	102				FilteredDataUsingAdvancedFilter
13	107
14
Sheet3 (2)

</SPAN>

Regards!

Yogi