finding duplicate values....

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
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!
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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
ABCD
4IDNumberDuplicate
5101No
6102No
7102Yes
8103No
9104No
10105No
11105Yes
12102Yes
13107No
Sheet3
</SPAN>

Regards!

Yogi
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
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
ABCDEF
1
2 
3
4IDNumberIDNumberNumberOfTimes Duplicated
51011023
61021052
71021023
8103
9104
10105sourcedata
11105criteriaforFilter
12102FilteredDataUsingAdvancedFilter
13107
14
Sheet3 (2)
</SPAN>

Regards!

Yogi
 

Watch MrExcel Video

Forum statistics

Threads
1,123,141
Messages
5,599,969
Members
414,353
Latest member
ljhan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top