VBA code Need for Extracting Dublicate values with count

**yugeshkumar** · 06-10-2021, 06:12 AM

I m having some details in Column A
in that details have information start with "via at xy"

like as n number of values. Excel attached and I did manually using count if formula , I m looking VBA code for those process.

step1-I wants to extract the all "via at xy" like (123456789) to column B
step2-using that column B value find no of times values repeated should entered in column C (ex: 1,2,3)
step3-two times repeated information copied in column D2, three times repeated values copied in column E2
step4- column D & E should have only unique values.

**Richard Buttrey** · 06-10-2021, 02:52 PM

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided.)

VBA code Need for Extracting Dublicate values with count

LinkBack

Thread Tools

Rate This Thread

Display

VBA code Need for Extracting Dublicate values with count

Re: VBA code Need for Extracting Dublicate values with count

Thread Information

Users Browsing this Thread

Similar Threads

VBA macro code need for extracting non duplicate values ?

VBA Code to Count a group of '1' values

Count Unique Values Conditionally -Code

VBA code to count specific values

[SOLVED] Delete Dublicate rows based on multi column values

EXCEL Count Dublicate Text - How?

aviod dublicate values

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions