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!
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,036
Messages
5,856,959
Members
431,841
Latest member
jaybeem

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