Help with Duplicates in a column

**sunnyimran** · 09-23-2019, 03:45 AM

Hi,

I have a long list of random numbers in a column ( e.g. column C ). Column C grows dynamically as new random values are copied/ appended at the last of existing list.

I want to find duplicated values in the whole(ever-growing) list and to copy each duplicated item in a another location on same sheet. If value '12345' occurred twice in the list, I want to display that count. For unique values take no action. Below is an example:

71658

71510

71658

71602

71658

71774

71667

71699

71700

71600

71585

71510

71742

71632

71649

71639

71594

Now I want to display this somewhere in same sheet

duplicates found= YES

Total duplicates= 5

value 71658 appeared 3 times

value 71510 appeared 2 times

Any suggestions?

**Pepe Le Mokko** · 09-23-2019, 03:53 AM

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**Pepe Le Mokko** · 09-23-2019, 03:53 AM

Hi and welcome
although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
So, please update your profile to something more precise then "Somewhere" ( country will suffice, no need to be more precise).
Thank you for helping us to help you

**sunnyimran** · 09-25-2019, 02:47 AM

Hi there,

Thanks for responding. To better describe what is needed I have created a plain Excel sheet which shows before and after

I cross-posted my question here: (answers.microsoft......)
<I got Error: You are not allowed to post any kinds of links, images or videos until you post a few times.>

Regards

**Pepe Le Mokko** · 09-25-2019, 02:53 AM

Please add the entire link as text and adapt your location. Thanks

**sunnyimran** · 09-25-2019, 06:04 AM

Originally Posted by Pepe Le Mokko

Please add the entire link as text and adapt your location. Thanks

h t t p s : / / a n s w e r s . m i c r o s o f t . c o m /en-us/msoffice/forum/all/help-with-duplicates-in-a-column/3b310bc1-ee6e-46e6-92a7-449ced5677ce

Help with Duplicates in a column

LinkBack

Thread Tools

Rate This Thread

Display

Help with Duplicates in a column

Re: Help with Duplicates in a column

Re: Help with Duplicates in a column

Re: Help with Duplicates in a column

Re: Help with Duplicates in a column

Re: Help with Duplicates in a column

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Identification of duplicates numbers in a column and print as duplicates with that number

[SOLVED] removing duplicates only within duplicates on another column

[SOLVED] Add up quantitites in Column E based on duplicates in Column A, then delete duplicates

[SOLVED] Find duplicates in column A, add values from column B (possibly delete duplicates)

[SOLVED] Find duplicates, concatenate into different column, sum and delete duplicates

[SOLVED] Macro to count unique values in a column, enter it in next column, then delete duplicates

Managing Duplicates: Extracting a list of duplicates from a column and creating a list.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions